Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> dba_extents and dba_segments

dba_extents and dba_segments

From: <genegurevich_at_discoverfinancial.com>
Date: Wed, 9 May 2007 15:34:29 -0500
Message-ID: <OF22657559.465FF51F-ON862572D6.00705F3B-862572D6.00710499@discoverfinancial.com>


Hi all:

I am very confused by the following 2 SQLs which I have ran against oracle 10.2.0.3. I have been under impression
that dba_Extents is a rollup of the dba_extents and therefore these two SQLs should return the same results.
This however does not seem to be the case. Does anyone know what is the reason for this?

SQL> select sum(bytes/1024)/1024 from dba_extents where tablespace_name =
'CCS_X_017';
SUM(BYTES/1024)/1024


               22200

  1* select sum(bytes/1024)/1024 from dba_segments where tablespace_name =
'CCS_X_017'

SQL> / SUM(BYTES/1024)/1024


                2400

thank you

Gene Gurevich

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 09 2007 - 15:34:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US