-
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
-
Can you tell us what you expecting stats frequency (day,week) and why you need to gather stats frequently?
Regarding AWR you need to configure it.
-
Originally Posted by malay_biswal
Can you tell us what you expecting stats frequency (day,week) and why you need to gather stats frequently?
Regarding AWR you need to configure it.
i need to configure once every hour and kept for 7 days.. the thing is that AWR not taking place in spite of all , could you please provide me solution!
-
Last edited by malay_biswal; 10-13-2008 at 08:33 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|