| Drill to Evaluate [message #133389] |
Thu, 18 August 2005 17:03  |
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.
|
|
|
|
 Re: Drill to Evaluate [message #133452 is a reply to message #133389] |
Fri, 19 August 2005 02:20  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
