Home » RDBMS Server » Performance Tuning » Drill to Evaluate
Drill to Evaluate [message #133389] Thu, 18 August 2005 17:03 Go to next message
rkl1
Messages: 97
Registered: June 2005
Member
Good Afternoon,

I face this situation now and then and here it is: the users complain that their query (running reports) or some running on massive dml(updates) running slow. How to systematically drill down to find out what exactly happening. I check often system_event, session_event and wait views. I wonder what would be systematic approach to these problems. What are the queries DBA could run to get more intelligent information. Also how to integrate the oracle finding to the server (unix) to validate that.

Thanks for all your help and attention.
icon6.gif  Re: Drill to Evaluate [message #133452 is a reply to message #133389] Fri, 19 August 2005 02:20 Go to previous message
kugenuma
Messages: 9
Registered: August 2005
Location: Japan
Junior Member
Hi rkl1
Generally, this kind of issue might be happened by following reason.
1.ITL contention
2.poor SQL logic

Pls try to get statspack!!

Best regards, kue.
Previous Topic: tuning with statpack
Next Topic: Strange Database Shutdowns
Goto Forum:
  


Current Time: Tue Dec 06 21:54:43 CST 2022