Home » RDBMS Server » Server Administration » Diff in dba_segments & dba_extents output. (Oracle 10G)
Diff in dba_segments & dba_extents output. [message #330078] Fri, 27 June 2008 09:33 Go to next message
liamadherne
Messages: 40
Registered: March 2008
Location: Philadelphia
Member
Hello Everyone

Can anybody put some light on the below output, Why there is the difference in the two outputs?

SQL> select sum(bytes)/1024/1024/1024 from dba_segments;

SUM(BYTES)/1024/1024/1024
-------------------------
1221.11511

SQL> select sum(bytes)/1024/1024/1024 from dba_extents;

SUM(BYTES)/1024/1024/1024
-------------------------
1213.16077


Thankyou.

Liam.
Re: Diff in dba_segments & dba_extents output. [message #330107 is a reply to message #330078] Fri, 27 June 2008 10:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68682
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Some bytes are not in extents.

Regards
Michel
Re: Diff in dba_segments & dba_extents output. [message #330319 is a reply to message #330078] Sun, 29 June 2008 08:04 Go to previous messageGo to next message
liamadherne
Messages: 40
Registered: March 2008
Location: Philadelphia
Member
Quote:
Some bytes are not in extents.


Does that mean dba_extents does not have the exact used information, and we should always query dba_segments ?.

Regards
Liam.
Re: Diff in dba_segments & dba_extents output. [message #330321 is a reply to message #330319] Sun, 29 June 2008 08:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68682
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dba_extents have information about extents.
dba_segments have information about segments.
Segments are made of extents + other things.

Regards
Michel
Re: Diff in dba_segments & dba_extents output. [message #330331 is a reply to message #330078] Sun, 29 June 2008 13:25 Go to previous message
liamadherne
Messages: 40
Registered: March 2008
Location: Philadelphia
Member
Thanks Got it.
Previous Topic: Multiple FREELIST
Next Topic: Capacity Planning
Goto Forum:
  


Current Time: Thu Sep 12 20:33:18 CDT 2024