AWR and restricted mode

  • From: amit poddar <amit.poddar@xxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 15 Nov 2006 12:46:36 -0500

Hi Folks,

SQL> exec dbms_workload_repository.create_snapshot;
BEGIN dbms_workload_repository.create_snapshot; END;

*
ERROR at line 1:
ORA-13516: AWR Operation failed: database in restricted mode
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 10
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 33
ORA-06512: at line 1


Is it documented anywhere that AWR snapshot cannot be taken when the database is in restricted mode ?

thanks
amit

--
//www.freelists.org/webpage/oracle-l


Other related posts: