Database Administration (MOSC)

MOSC Banner

Difference between dba_segments and dba_extents

edited Apr 5, 2011 4:46AM in Database Administration (MOSC) 14 commentsAnswered
 Any idea about the reason for Difference between dba_segments and dba_extents , 11g DB
SQL> select sum(bytes)/1024/1024 as sum_used_via_segments
2 from dba_segments
3 where tablespace_name='ARISDATA'
4 and segment_name not like 'BIN$%';

SUM_USED_VIA_SEGMENTS
---------------------
5282,6875

SQL> select sum(bytes)/1024/1024 as sum_used_via_extents
2 from dba_extents
3 where tablespace_name='ARISDATA';

SUM_USED_VIA_EXTENTS
--------------------
5188,6875

SQL> select owner, segment_name, partition_name, segment_type, tablespace_name,header_block, blocks
2 from dba_segments
3 where tablespace_name='ARISDATA'
4 and segment_name not in(
5 select segment_name
6 from dba_extents
7 where tablespace_name='ARISDATA'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center