Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> dba_extents and dba_segments
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-lReceived on Wed May 09 2007 - 15:34:29 CDT
![]() |
![]() |