Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> AWR and restricted mode

AWR and restricted mode

From: amit poddar <amit.poddar_at_yale.edu>
Date: Wed, 15 Nov 2006 12:46:36 -0500
Message-ID: <455B527C.1010005@yale.edu>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 15 2006 - 11:46:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US