| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: how to identify non-system and sys tables that have out of date statistics.
krish wrote:
> Hi I have an confused problem
> i.e. identify non-system and sys tables that have out of date
> statistics and build a script to update the statics for the table that
> were identifued.
> Please send me some sample scripts.
>
> Thanks in advance.
>
> -Krishna
Try something like this (I have it set to only show me less than 50)
set pagesize 100;
select owner,table_name,last_analyzed from dba_tables
where owner not in ('SYS','SYSTEM') and last_analyzed<(SYSDATE-1) and
rownum<50
order by owner, table_name;
Received on Thu Feb 23 2006 - 10:48:49 CST
 |
 |