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: Table stats in 10.2

Re: Table stats in 10.2

From: <bdbafh_at_gmail.com>
Date: 28 Apr 2006 07:58:39 -0700
Message-ID: <1146236319.316945.266190@g10g2000cwb.googlegroups.com>


Ed,

This one will do.

http://wtcis.wtamu.edu/oracle/server.101/b10752/stats.htm

BEGIN
  DBMS_SCHEDULER.DISABLE('GATHER_STATS_JOB'); END;
/

Or one could drop the job entirely.

-bdbafh Received on Fri Apr 28 2006 - 09:58:39 CDT

Original text of this message

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