Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_stats automatic collection in 10g
PS your subject line says 10g but your post says 9.2.0.6, which is it?
In 10g Oracle uses the scheduler (dbms_schedule) to run a job, GATHER_STATS_JOB, to generate object level statistics. See the PL/SQL Packages and Types Reference for details on dbms_schedule. See the DBA Administration manual and Ch 23 of the DBA Administrators Guide, Managing Automatic System Tasks Using the Maintenance Window.
HTH -- Mark D Powell -- Received on Thu May 11 2006 - 15:43:41 CDT