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

From: Mark G Phillips <mphillips_at_delphius.freeserve.co.uk>
Date: Fri, 24 Nov 2000 16:56:51 GMT
Message-ID: <3a1e9dd2.30064834@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 Fri Nov 24 2000 - 10:56:51 CST