Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Best way to call dbms_stats
"M.a.x G.e.decke" wrote:
> thanks for the fast reply
> do you know any websites where I can take a look at sql skripts executing
> the dbms_stats package?
>
> max
I think you'd be hard pressed to find scripts for this. My usual is something like:
BEGIN
dbms_stats.gather_schema_stats(OWNNAME => schema_owner, CASCADE => TRUE);
END;
Then let dbms_job do the heavy lifting.
Daniel Morgan Received on Tue Aug 20 2002 - 10:44:05 CDT