Re: dba_extents and dba_segments
- From: rjamya <rjamya@xxxxxxxxx>
- To: genegurevich@xxxxxxxxxxxxxxxxxxxxx
- Date: Thu, 10 May 2007 06:44:40 -0400
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:
