Home » RDBMS Server » Performance Tuning » How to enable AWR in oracle 10g (10g, 10.2.0.1, windows XP)
How to enable AWR in oracle 10g [message #589945] Fri, 12 July 2013 05:46 Go to next message
suman1986
Messages: 3
Registered: July 2013
Location: Mumbai
Junior Member
Hi All,

I am new to this forum. I have installed database in one server. I would like to enable AWR into it.
Statistics_level is set to Typical. While running the below script to enable the AWR, its gives error -

SQL> exec dbms_scheduler.enable('GATHER_STATS_JOBS');
BEGIN dbms_scheduler.enable('GATHER_STATS_JOBS'); END;

*
ERROR at line 1:
ORA-27476: "SYS.GATHER_STATS_JOBS" does not exist
ORA-06512: at "SYS.DBMS_ISCHED", line 4343
ORA-06512: at "SYS.DBMS_SCHEDULER", line 2802
ORA-06512: at line 1



Kindly help me out to make AWR automatical generation.

Regards,
Suman
Re: How to enable AWR in oracle 10g [message #589946 is a reply to message #589945] Fri, 12 July 2013 05:55 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum.

Try enabling GATHER_STATS_JOB

(there is only one of them)
Re: How to enable AWR in oracle 10g [message #589947 is a reply to message #589946] Fri, 12 July 2013 05:58 Go to previous messageGo to next message
suman1986
Messages: 3
Registered: July 2013
Location: Mumbai
Junior Member
Sorry..

below are the query ..

SQL> exec dbms_scheduler.enable('GATHER_STATS_JOB');
BEGIN dbms_scheduler.enable('GATHER_STATS_JOB'); END;

*
ERROR at line 1:
ORA-27476: "SYS.GATHER_STATS_JOB" does not exist
ORA-06512: at "SYS.DBMS_ISCHED", line 4343
ORA-06512: at "SYS.DBMS_SCHEDULER", line 2802
ORA-06512: at line 1


Re: How to enable AWR in oracle 10g [message #589949 is a reply to message #589947] Fri, 12 July 2013 06:10 Go to previous message
suman1986
Messages: 3
Registered: July 2013
Location: Mumbai
Junior Member
Dear All,

I ran the below script

execute dbms_workload_repository.modify_snapshot_settings(interval => 60,retention => 20160);



It enable AWR Snapshots.


Below site is good enough to understand about it
http://docs.oracle.com/cd/B12037_01/appdev.101/b10802/d_wkrpos.htm

Previous Topic: Full Table scan - Query without where clause
Next Topic: Script to load Trace files errors to a Table
Goto Forum:
  


Current Time: Fri Mar 29 10:06:42 CDT 2024