OraFAQ Forum: Server Administration » resmgr:waiting in end wait

Home » RDBMS Server » Server Administration » resmgr:waiting in end wait

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

resmgr:waiting in end wait [message #218405]

Thu, 08 February 2007 01:40

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

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Previous Topic:	cold backup of controlfile raw device
Next Topic:	How to create a database in client

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 15:53:26 CST 2024