Re: dba_extents and dba_segments

I don't see that ...

oraclei_at_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_at_discoverfinancial.com < genegurevich_at_discoverfinancial.com> 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
>
>

--
http://www.freelists.org/webpage/oracle-l