OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Tuning Needed

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tuning Needed [message #223439]

Thu, 08 March 2007 22:38

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 19 11:31:20 CDT 2026