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 #219326]

Wed, 14 February 2007 00:55

Nitin Bane
Messages: 10
Registered: March 2003

Junior Member

I am facing problem with database performance

Top 5 timed events in statspack report

Event Waits Time (s) Ela Time
resmgr:waiting in end wait________ 6,071,849_____198,233____52.78
db file scattered read____________ 7,760,498______79,592____21.19
CPU time____________________________________54,224____14.44
db file sequential read____________3,850,842______24,723_____6.58
enqueue__________________________2,655_______7,726_____2.06

Can anybody help me to find what could be the problem?

Thankx & regards

NITIN

Report message to a moderator

Re: resmgr:waiting in end wait [message #219328 is a reply to message #219326]

Wed, 14 February 2007 00:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can anybody help me to find what could be the problem?
Not enough low level data to identify any specific problem.
If you think you know the problem,then fix it.

Report message to a moderator

Re: resmgr:waiting in end wait [message #219337 is a reply to message #219328]

Wed, 14 February 2007 01:15

Nitin Bane
Messages: 10
Registered: March 2003

Junior Member

What sort of data you want?
If you specify email, I can send you complete statspack report

Thanx

Report message to a moderator

Previous Topic:	removing jobs from 10g schduler
Next Topic:	ora-03134 when connecting from 10gR2 to 8.1.7

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 15:33:46 CST 2024