Re: Table Analysis Info

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Tue, 12 Mar 2002 17:19:46 +0100
Message-ID: <3C8E2AA2.3EB501F5@mytoys.de>

> If you want to know whether tables are being analyzed run the following:
>
> SELECT table_name
> FROM user_tables
> WHERE num_rows IS NULL;
>
> If any rows are returned analysis has not been done since whenever the oldest
> of those tables was created.

What about querying LAST_ANALYZED from user_tables ?

> But as a DBA I think you are taking the wrong approach: Go ask!

Maybe his/her DBA is very busy... Or he/she has some problems with him...

Regards,

Knut Received on Tue Mar 12 2002 - 10:19:46 CST