1.1 To create awr reports using command line.
• We need to connect OS to Oracle user.
• We need to enter spesific directory where some oracle basic scripts are avaliable “cd $ORACLE_HOME/rdbms/admin/” .
• Now time to connect sqlplus “sqlplus / as sysdba” .
• And now we need to execute awr script “@$ORACLE_HOME/rdbms/admin/awrrpt.sql” .
Creating AWR report using command line