Thread Analysis

grep "\- waiting on" filename | awk '{print $4;}'|sort | uniq -c

cat API_100_0417_1|grep java.lang.Thread.State| awk '{print $2;}'|sort | uniq -c

Generate AWR Report

1. su – oracle
2. sqlplus “/ as sysdba”
3. SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql