Home » RDBMS Server » Server Administration » resmgr:waiting in end wait
resmgr:waiting in end wait [message #218405] Thu, 08 February 2007 01:40 Go to next message
Nitin Bane
Messages: 10
Registered: March 2003
Junior Member
I am facing performance problem

Server show low load average and significant idle
but database is dead slow

statspack output for to wait events are as follows
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~                                                     ------------------------------------------------------- %Total
Event ------------------------- Waits -------- Time (s)  Time
resmgr:waiting in end wait----- 4,456,218 ---- 62,135 -- 32.13
CPU time ------------------------------------- 55,562    28.73
db file scattered read -------- 7,097,897 ---- 53,797 -- 27.82
db file sequential read ------- 2,161,603 ---- 8,273 --- 4.28
enqueue --------------------------- 2,395 ----- 7,020 --- 3.63

Please guide me what could be the problem area?
which resource gives problem?

Thankx & regards

NITIN

[Updated on: Thu, 08 February 2007 05:50] by Moderator

Report message to a moderator

Re: resmgr:waiting in end wait [message #218461 is a reply to message #218405] Thu, 08 February 2007 05:52 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> resmgr:waiting in end wait
Mostly has to do with dblinks/external procedures.
Isolate the sql using those and try to analyze it.
Previous Topic: cold backup of controlfile raw device
Next Topic: How to create a database in client
Goto Forum:
  


Current Time: Fri Dec 09 03:54:53 CST 2016

Total time taken to generate the page: 0.11949 seconds