dba_extents and dba_segments
- From: genegurevich@xxxxxxxxxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 9 May 2007 15:34:29 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
