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: Best way to call dbms_stats

Re: Best way to call dbms_stats

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 20 Aug 2002 15:44:05 GMT
Message-ID: <3D6263B9.1237321@exesolutions.com>


"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

Original text of this message

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