Re: Newbie Question: Where do I find Oracle 8 Stats?

The concept you seem to be missing is that oracle stores information about the database IN the database itself. This is what Sybrand is saying when he mentions the 'data dictionary'. These dictionary tables are automatically updated by Oracle itself.

"Mark G Phillips" <mphillips_at_delphius.freeserve.co.uk> wrote in message news:3a1e9dd2.30064834_at_news.ntlworld.com...
> On Fri, 24 Nov 2000 11:48:21 -0000, "andrew_webby at hotmail"
> <spam_at_no.thanks.com> wrote:
>
> >select * from dba_segments where owner not in ('SYS','SYSTEM');
> >
> Thanks, it' sort of the right info.
>
> I've been playing with the data dictionary view 'user_tables', but you
> have to run analyze on each individual table you want to include in
> your stats in order to update the information. It makes it more
> difficult to automate the process as you have to know which tables
> you're going to process in advance. If anyone adds a table, then the
> process needs changing to include the new table.
>
> Do you have to do the same thing with dba_segments, or is the
> information updated dynamically?
>
> Or am I barking up the wrong tree and you need to buy a hideously
> expensive utility from Oracle to produce dynamic stats?
>
> Mark.
>
Received on Mon Nov 27 2000 - 05:05:37 CST