Re: Activating / Rebuilding Statistics

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 25 Aug 2003 17:37:50 -0700
Message-ID: <2687bb95.0308251637.39685527@posting.google.com>

"Sha" <ssha53_at_singnet.com.sg> wrote in message news:<bie1jv$rtk$1_at_reader01.singnet.com.sg>...
> Hi
>
> We are running Oracle v 8.1.7.
> Can someone kindly tell me how to check/activate if the statistics for the
> tables are turned on ?
>
> Thanks in advance.

To turn on statistics you must first generate them using either the analyze command or the dbms_stats package.

You can tell when statistics were last generated for an object by looking at the last_analyzed date column in dba_tables and dba_indexes.

See the Concepts manual for a general discussion. DBMS_STATS is documented in the Oracle Supplied Packages manual Analyze is documented in the SQL manual

HTH -- Mark D Powell -- Received on Mon Aug 25 2003 - 19:37:50 CDT