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.

Report message to a moderator

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: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How to Identify Performance Problem and Bottleneck

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 25 02:10:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.