Home » RDBMS Server » Performance Tuning » find the query/plsql block which is causing performance hurt (oracle 10.2.0.2 solaris 10)
find the query/plsql block which is causing performance hurt [message #276622] Thu, 25 October 2007 11:27 Go to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
Hi,

I am kumar. I got one problem.
1.one of my user is runnig one report. yesterday it is taking 5 minits. today 35 minitus. what could be the problem. how do i trace it.

nearly 600 users are connectd my database and one user is runnig the report.how would i know which sql /plsql block is causing and how would i find that query/plsql block.

Re: find the query/plsql block which is causing performance hurt [message #276630 is a reply to message #276622] Thu, 25 October 2007 11:48 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How to Identify Performance Problem and Bottleneck

Regards
Michel
Previous Topic: Slow SQL with dedicated server?
Next Topic: want to reduce the COST
Goto Forum:
  


Current Time: Thu Dec 08 20:22:47 CST 2016

Total time taken to generate the page: 0.04942 seconds