Tuesday 14 February 2017

How to generate AWR report from Oracle Database 11g

Execute below script to run AWR report.

set ORACLE_SID=HRPROD
sqlplus / as sysdba;
@$ORACLE_HOME/rdbms/admin/awrrpt.sql


Check Files.
 
cd $ORACLE_HOME/rdbms/admin.
ls -lrt awr*

No comments:

Post a Comment

Jenkins Startup and Configuration

Steps to setup jenkins on ubuntu:- -After installation. check the jenkins services running on not on the server. sudo service jenk...