Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to identify non-system and sys tables that have out of date statistics.

Re: how to identify non-system and sys tables that have out of date statistics.

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Tue, 21 Feb 2006 17:37:24 +0100
Message-ID: <dtffk4$d5h$1@nntp.fujitsu-siemens.com>


krish schrieb:
> 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.

gather_database_stats does this automatically. Received on Tue Feb 21 2006 - 10:37:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US