Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> difference in dba_tables and dba_segments??

difference in dba_tables and dba_segments??

From: Ben <balvey_at_comcast.net>
Date: 20 Jun 2006 07:58:45 -0700
Message-ID: <1150815525.011262.68110@u72g2000cwu.googlegroups.com>


Running Enterprise 9.2.0.5 with the compatible parameter set to 8.1.0 on an IBM Unix/AIX5L system.
Why would the following selects return a different value for blocks? This table is analyzed using dbms_stats.gather_schema_stats.

select owner, segment_name, round(blocks*8/1024,2) as Megs from dba_segments
where owner = 'PRODDTA'
and segment_name = 'F0911'

returns 35840.02 for Megs

select owner, table_name, round(blocks*8/1024,2) as Megs from dba_tables
where owner = 'PRODDTA'
and table_name = 'F0911'

returns 35750.84 for Megs

I'd rather use dba_table instead of joining between the two to get num_rows, last_analyzed, and size values, but if these are returning different values how do I know which one is correct? Thank you,
Ben Received on Tue Jun 20 2006 - 09:58:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US