Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AWR - oracle 10g is not running.. please help

knowledgespringOct 10 2008 — edited Oct 18 2008
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


thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2008
Added on Oct 10 2008
#general-database-discussions
14 comments
1,611 views