Home » RDBMS Server » Performance Tuning » Tuning Needed
Tuning Needed [message #223439] Thu, 08 March 2007 22:38 Go to next message
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.
Re: Tuning Needed [message #223442 is a reply to message #223439] Thu, 08 March 2007 22:44 Go to previous messageGo to next message
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Take a look at STATSPACK in the Performance Tuning Manual.

Ross Leishman
Re: Tuning Needed [message #226396 is a reply to message #223439] Fri, 23 March 2007 09:11 Go to previous message
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
Previous Topic: Caling package
Next Topic: 10gR2 impossible de lancer DBCONSOLE
Goto Forum:

Current Time: Wed Oct 26 04:52:51 CDT 2016

Total time taken to generate the page: 0.15210 seconds