Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: difference in dba_tables and dba_segments??
Ben wrote:
> 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?
Umm because it is the accurate answer? Received on Wed Jun 21 2006 - 10:03:30 CDT