OraFAQ Forum: Performance Tuning » find the query/plsql block which is causing performance hurt

Home » RDBMS Server » Performance Tuning » find the query/plsql block which is causing performance hurt (oracle 10.2.0.2 solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

find the query/plsql block which is causing performance hurt [message #276622]

Thu, 25 October 2007 11:27

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