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

"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.
>

Dba_segments is a view on the datadictionary. The datadictionary is updated dynamically. You should never ever analyze the datadictionary. By issuing
execute dbms_utility.analyze_schema('<USERNAME>','COMPUTE') you can analyze an entire schema in one go. Reading manuals usually pays itself back, you are now already embarking on a route which eventually will cost you much more time.

Regards,

Sybrand Bakker, Oracle DBA Received on Fri Nov 24 2000 - 11:58:45 CST