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


  1* select sum(bytes/1024)/1024 from dba_segments where tablespace_name =
SQL> /


thank you

Gene Gurevich


Other related posts: