Re: dba_extents and dba_segments

I don't see that ...

oraclei@xxx> sys yyy

SQL*Plus: Release 10.2.0.3.0 - Production on Thu May 10 06:40:58 2007
Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining
options

SQL> set timing on
SQL> select sum(bytes/1024)/1024 from dba_extents where tablespace_name =
'XXXDATA';

SUM(BYTES/1024)/1024
--------------------
         966505.375

Elapsed: 00:00:16.52
SQL> select sum(bytes/1024)/1024 from dba_segments where tablespace_name =
'XXXDATA';

SUM(BYTES/1024)/1024
--------------------
         966102.188

Elapsed: 00:00:00.27


400mb is missing, but that could very well be dropped objects etc.
rjamya

On 5/9/07, genegurevich@xxxxxxxxxxxxxxxxxxxxx <
genegurevich@xxxxxxxxxxxxxxxxxxxxx> wrote:



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

Other related posts: