Home » RDBMS Server » Performance Tuning » Tuning Needed
Tuning Needed [message #223439] Thu, 08 March 2007 22:38 Go to next message
sanjay_kant
Messages: 25
Registered: February 2007
Junior Member
my database is working very good till tomorrow evening but when i open my database today after 20 mints a user complient that database is very slow.

no errors in Alert log. how to diagnose the problem n how to solve it.

Report message to a moderator

Re: Tuning Needed [message #223442 is a reply to message #223439] Thu, 08 March 2007 22:44 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Take a look at STATSPACK in the Performance Tuning Manual.
Ross Leishman

Report message to a moderator

Re: Tuning Needed [message #226396 is a reply to message #223439] Fri, 23 March 2007 09:11 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Certain things happen when a db is opened. Did it get shutdown with shutdown abort? That sometimes needs time to make the db consistant.
Other issues can be
1) allocating memory
2) bringing in blocks to the sga that are in memory after the first fetch.
3) run packages on startup

Report message to a moderator

Previous Topic: Caling package
Next Topic: 10gR2 impossible de lancer DBCONSOLE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 04:05:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.