Home » RDBMS Server » Server Administration » resmgr:waiting in end wait
resmgr:waiting in end wait [message #219326] Wed, 14 February 2007 00:55 Go to next message
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
Re: resmgr:waiting in end wait [message #219328 is a reply to message #219326] Wed, 14 February 2007 00:58 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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.
Re: resmgr:waiting in end wait [message #219337 is a reply to message #219328] Wed, 14 February 2007 01:15 Go to previous message
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
Previous Topic: removing jobs from 10g schduler
Next Topic: ora-03134 when connecting from 10gR2 to 8.1.7
Goto Forum:
  


Current Time: Sat Dec 03 12:19:28 CST 2016

Total time taken to generate the page: 0.07636 seconds