Oracle stores the sql scripts at '$ORACLE_HOME/rdbms/admin/' these can be executed from here

Razi Abuzar's picture

Command to get awr report for a particular SQLID is:

@?$ORACLE_HOME/rdbms/admin/awrsqrpt.sql

 

Command to get the awr report:

@?$ORACLE_HOME/rdbms/admin/awrrpt.sql

Tags: 

0 points
up
down