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: 3727
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: Reverse Key Index
Next Topic: all about db_block_size
Goto Forum:

Current Time: Sun Aug 20 12:07:37 CDT 2017

Total time taken to generate the page: 0.04617 seconds