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.

Report message to a moderator

- 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.

Report message to a moderator

Previous Topic: tuning with statpack
Next Topic: Strange Database Shutdowns
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 17 01:44:40 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.