OraFAQ Forum: Performance Tuning » How to enable AWR in oracle 10g

Home » RDBMS Server » Performance Tuning » How to enable AWR in oracle 10g (10g, 10.2.0.1, windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to enable AWR in oracle 10g [message #589945]

Fri, 12 July 2013 05:46

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

Report message to a moderator

Re: How to enable AWR in oracle 10g [message #589946 is a reply to message #589945]

Fri, 12 July 2013 05:55

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum.

Try enabling GATHER_STATS_JOB

(there is only one of them)

Report message to a moderator

Re: How to enable AWR in oracle 10g [message #589947 is a reply to message #589946]

Fri, 12 July 2013 05:58

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

Report message to a moderator

Re: How to enable AWR in oracle 10g [message #589949 is a reply to message #589947]

Fri, 12 July 2013 06:10

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 11 07:11:27 CDT 2025