generate ash report from sqlplus
plan to make a script with time range as input values open in browser: add for mac os x add for linux:
ash
Query optimization:
awr_top2 script ASH_SQLMON look at plan line 3 in ash: this substr(this_.response_content, 0, 5) query high compressed clob field after talking with the developers on the subject, why would they need these first 5 characters, they agreed to remove them from the query. After editing query the server load is 3 times lower