Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: difference in dba_tables and dba_segments??
Mladen Gogala wrote:
> On Tue, 20 Jun 2006 07:58:45 -0700, Ben wrote:
>
> > 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,
>
> Very simple: go through DBA_EXTENTS and sum up sizes of all extents
> comprising the table. See which number will you get. My guess is that
> the number will be the one from DBA_SEGMENTS for the reason mentioned
> by Brian.
>
> --
> http://www.mgogala.com
So why would you use DBA_EXTENTS as the golden rule as to what it should be? Received on Wed Jun 21 2006 - 08:21:42 CDT