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

Report message to a moderator

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

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 10:05:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.