Pavan DBA's Blog

The DBA Knowledge Store

AWR report in restricted mode

Posted by Pavan DBA on February 8, 2018


Today, I have learned new thing regarding AWR report when database is in restricted mode.

By default, if your database is in restricted mode, you cannot generate AWR report. It will throw below error in the alert log.

ORA-13516: AWR Operation failed

or

ORA-20200: Database/Instance nnnnnn does not exist in DBA_HIST_DATABASE_INSTANCE

This is because Oracle database will not allow to generate AWR report in restricted mode. To still continue with report generation, you need to set below hidden parameter in your spfile

_AWR_RESTRICT_MODE

Steps to perform:

  1. alter system set _awr_restrict_mode=TRUE scope=SPFILE; -> Default value is FALSE
  2. srvctl stop database -d <database_name> (for RAC, restart node by node)

But, there is a limitation for this parameter. When it is set to TRUE, AWR snapshots will not generate during OPEN mode and you need to change this parameter back to FALSE.

Posted in Perf Tuning | Tagged: , , , , | Leave a Comment »

TechMaster – New Performance tuning batch from 8th Jan

Posted by Pavan DBA on January 3, 2018


TechMaster announcing Oracle Performance Tuning online training by Kumar

Mode: Online training
Duration: 20 classes
Frequency: 5 days a week
Timings: 7 – 8 AM IST
Batch starting date: 9th Jan 2018 at 7 AM IST

Demo date & time: 8th Jan 2018 at 7 AM IST
Please attend demo and first two classes for free (9th and 10th Jan) using this link – https://global.gotomeeting.com/join/746566549

For more details, contact:-
Email to: admin@thetechmaster.in
Call or WhatsApp to: +919676516545
http://www.thetechmaster.in

Posted in General | Leave a Comment »

TechMaster – New Oracle Performance Tuning batch from 6th Nov

Posted by Pavan DBA on October 31, 2017


TechMaster announcing Oracle Performance Tuning online training by Kumar

Mode: Online training
Duration: 20 classes
Frequency: 5 days a week
Timings: 6 – 7 AM IST
Batch starting date: 6th Nov 2017 @ 6 AM IST

Demo date & time: 4th Nov 2017 at 6 AM IST
Please attend demo and first two classes for free using this link – https://global.gotomeeting.com/join/871212917

For more details, contact:-
Email to: admin@thetechmaster.in
Call or WhatsApp to: +919676516545
http://www.thetechmaster.in

Posted in Training | Tagged: , , , , , , | Leave a Comment »

Fresher opening

Posted by Pavan DBA on October 30, 2017


Posted in General, Jobs | Leave a Comment »

Fresher Openings in TCS

Posted by Pavan DBA on October 27, 2017


Posted in General, Jobs | Leave a Comment »

 
%d bloggers like this: