Re: How to use dbms_stats.

[Marin Dimitrov]

 

----- Original Message -----

From: <[EMAIL PROTECTED]>

 

>
> I want to know how to how to use dbms_stats. package and get the statistics
>

short answer:

begin
    dbms_stats.gather_schema_stats(ownname => 'XXXX',cascade=>true);
end;

 

 

for a detailed explanation take a look at

 

http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a87503/stats.htm#26333

http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/dbms_sta.htm#999107

 

 

hth,

 

    Marin

 

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "