AWR - oracle 10g is not running.. please help
Hi,
there are no awr snapshots and i investigated and found the following.. can you please suggest how to make GATHER_STATS_JOB run frequently?
SQL> select job_name,STATE,ENABLED, START_DATE from dba_scheduler_jobs;
JOB_NAME STATE ENABL START_DATE
--------------- ---------------------------------------------------------------------------
PURGE_LOG SCHEDULED TRUE 15-FEB-06 03.00.00.100000 AM -01:00
GATHER_STATS_JOB SCHEDULED TRUE
SQL> select * from dba_hist_snapshot;
no rows selected
DB: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit
OS: SunOS 5.8
thanks in advance
