Home » RDBMS Server » Performance Tuning » Sparodic database slowness
Sparodic database slowness [message #295518] Tue, 22 January 2008 09:04 Go to next message
Messages: 13
Registered: December 2007
Location: Warrington, UK
Junior Member
I have noticed over the last few months that occasionally, the db appears to slow right down, for no apparent reason. It never seems to happen at the same time, and i've looked at longops and running jobs, processes and memory useage, but can never see anything that might indicate why it has slowed down. Then all of a sudden, and i don't do anything, normal performance is resumed. Any ideas what else i can look at to assist me in this?


Stew Confused
Re: Sparodic database slowness [message #295521 is a reply to message #295518] Tue, 22 January 2008 09:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
This could be a wild goose chase Smile.
Are there any other services hosted in the same server?
Did you check the OS backup schedule?
Is there any scheduled database jobs?

[Updated on: Tue, 22 January 2008 09:33]

Report message to a moderator

Re: Sparodic database slowness [message #295532 is a reply to message #295518] Tue, 22 January 2008 10:16 Go to previous message
Michel Cadot
Messages: 63923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Full moon?

Previous Topic: how to specify priority of active sql sessions running in the database
Next Topic: Query Profiler tool
Goto Forum:

Current Time: Tue Oct 25 20:03:58 CDT 2016

Total time taken to generate the page: 0.19203 seconds