perfomance

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