Home » RDBMS Server » Performance Tuning » slow server
slow server [message #133078] Wed, 17 August 2005 10:19 Go to next message
mjschwenger
Messages: 137
Registered: July 2005
Location: US
Senior Member
One of my servers is slow this week with no obvious reason.
There's plenty of space, memory, no locks and blocks, no bad sql found, etc. The OS CPU is 98 and up, memory swappin - high...
What will be the best way to find out what's goign on on the box?
Thanks a lot,
mj
Re: slow server [message #133085 is a reply to message #133078] Wed, 17 August 2005 11:34 Go to previous message
mjschwenger
Messages: 137
Registered: July 2005
Location: US
Senior Member
All the waits I have are on the SQL*Net break/reset to client, SQL*Net message to client, wait for unread message on broadcast channel.
DBSNMP and SYSMAN are the top users.
Right now there's 1 user on the box running:
Drop User UName cascade; - for 4 old users
EM doesn't respond at all - restarting did not help.
Any advise is greatly appreciated.
Thanks,mj
Previous Topic: Move Production database to test environment for load tests
Next Topic: How to make this query fast?
Goto Forum:
  


Current Time: Fri Dec 09 13:05:51 CST 2022