dba_extents view in Oracle 10.2.0.2 2006-06-26 - By genegurevich@(protected)
Yes.
The ETL tool we are using (Ab Initio) queries this and a few other dba_ views when loading the tables.
thank you
Gene Gurevich Oracle Engineering 224-405-4079
"Connor McDonald" <mcdonald.connor@ gmail.com> To Sent by: oracle-l <oracle-l@(protected)> oracle-l-bounce@(protected) cc reelists.org Subject Re: dba_extents view in Oracle 06/25/2006 07:56 10.2.0.2 AM Please respond to mcdonald.connor@(protected) mail.com
On 6/24/06, genegurevich@(protected) < genegurevich@(protected)> wrote: Everybody:
Has anyone experienced performance issues with dba_extents view (bug 5029334)? I was told by Oracle that the workaround is to create a new view and use it instead of dba_extents. When I asked whether I can just recreate the dba_extents view I was told that the results can be far reaching and should be fully tested. I interpret that as Oracle does not really know what the results are. I wanted to see if anyone has hit this bug and what did you do.
thank you
Gene Gurevich
-- http://www.freelists.org/webpage/oracle-l
Is there any particular urge to be querying DBA_EXTENTS with any great frequency anyway ?
-- Connor McDonald =========================== email: connor_mcdonald@(protected) web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
-- http://www.freelists.org/webpage/oracle-l
|
|