Home » RDBMS Server » Performance Tuning » Sparodic database slowness
Sparodic database slowness [message #295518] Tue, 22 January 2008 09:04 Go to next message
oraclestew
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?

Cheers

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: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Full moon?

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


Current Time: Sat Dec 10 09:00:06 CST 2016

Total time taken to generate the page: 0.22048 seconds