You can also
DBMS_STATS.GATHER_SCHEMA_STATS

And this ought to be run regularly on the SYS schema.

| Henry A.L. Wollman Rejoice and be glad!
|_____________________________________________________
| Moody Bible Institute, Database Administrator, [Email address protected]
| 820 N. LaSalle Blvd, Chicago, IL 60610 312-329-2291
|_____________________________________________________
-----Original Message-----
From: Sachidananda_T
[mailto:oracledba-ezmlmshield-x16343912.[Email address protected]
Sent: Wednesday, September 28, 2005 11:29 PM
To: LazyDBA Discussion
Subject: RE: dbms_stats

Hi,

DBMS_STATS.GATHER_TABLE_STATS should be used on large tables.

It would gather the statistics of the table and store it in the data
dictionary.

Hence further DML statements would be faster.

It can be used from any schema user.

Regards
Sachi

-----Original Message-----
From: Vishal Agarwal
[mailto:oracledba-ezmlmshield-x15287681.[Email address protected]
Sent: Thursday, September 29, 2005 10:05 AM
To: LazyDBA Discussion
Subject: dbms_stats


hello all
can anybody tell me what is the advantage of
using dbms_stats package for gathering table stats
and whether I should run it from sys or from
users scheme which has the table
thanks



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




DISCLAIMER:
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page