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-l

Other related posts: