Home » RDBMS Server » Performance Tuning » Prameters For Improving DB Perfomance
Prameters For Improving DB Perfomance [message #119668] Fri, 13 May 2005 12:44 Go to next message
ksst
Messages: 10
Registered: February 2005
Junior Member

Hi,

Could I have information on the parameters that need to be changed to improve the performance of a Database.

Are there any books or specific documents that give information in this regard.

Any information would be of immense help.

Thanks in advance.
Sri Sai Krishna
Re: Prameters For Improving DB Perfomance [message #119685 is a reply to message #119668] Fri, 13 May 2005 15:10 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Just add the following line to your init.ora and everything will run super duper fast:

vroom_vroom = true

Just kidding...

there is no such parameter. Best to read things like the oracle concepts guide, and understand your system, and then use that understanding to improve performance.

[Updated on: Fri, 13 May 2005 22:30]

Report message to a moderator

Re: Prameters For Improving DB Perfomance [message #119707 is a reply to message #119685] Fri, 13 May 2005 19:05 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Come on smartin - give the man a few places to start looking...
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6575484748500
http://miracleas.dk/tools/YAPP_Tuning_Final.pdf
http://www.quest.com/whitepapers/mythsandfolkloreaboutoracleperformancetuning-3.pdf
Re: Prameters For Improving DB Perfomance [message #119709 is a reply to message #119668] Fri, 13 May 2005 22:33 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Good post Andrew, and good links. Point well taken.
Previous Topic: statspack top 5 wait event
Next Topic: Ploblem connect oracle by Vb application
Goto Forum:
  


Current Time: Wed Sep 30 11:45:28 CDT 2020