Re: dba_extents view in Oracle 10.2.0.2

From: <genegurevich_at_discoverfinancial.com>
Date: Mon, 26 Jun 2006 07:55:21 -0500
Message-ID: <OF6821152D.B663C477-ON86257199.0046DE09-86257199.0046EF44@discoverfinancial.com>

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_at_freelists.org>   
             oracle-l-bounce_at_f                                          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_at_g                                             
                 mail.com

On 6/24/06, genegurevich_at_discoverfinancial.com < genegurevich_at_discoverfinancial.com> 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_at_yahoo.com
web: http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jun 26 2006 - 07:55:21 CDT