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: 10677
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: 65138
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: Thu Aug 17 23:41:57 CDT 2017

Total time taken to generate the page: 0.11790 seconds