Database Version = 10.2.0.3
Problem : High CPU consumption.
Solution : Based on the above top 5 events one can cleary see that db file scattered read is high event after the CPU, which means that the application is performing full tablescans. Based on this one has to look at SQL ordered by CPU session of the report to find out which queries on performing full table scan. Based on the index recommendations the above problem has been sorted out.
Team ORAKHOJ
You can also get free tuning analysis from our database experts. Please send a mail to tuning@orakhoj.com
No comments:
Post a Comment