Home » RDBMS Server » Performance Tuning » steps for tuning oracle...!
steps for tuning oracle...! [message #127603] Tue, 12 July 2005 08:30 Go to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
hai experts,

here in our firm we have to create the report on how the oracle database to be tuned to increase the performance.being the junior DBA we dont have enough idea on performance to proceed.so could u plz give us the steps like the queries to be used to view the certain parameters based on which tuning holds like wise how to proceed to increase the performance which would be useful for us..?being a urgent issue , plz give the steps to perform in the reply itself as we dont have time to see the documentation and search for the procedures as the position is like that..!sorry for this interruption.thanks in advance.

database-->oracle 9i
os--->linux

regards
bala

[Updated on: Tue, 12 July 2005 08:32]

Report message to a moderator

Re: steps for tuning oracle...! [message #127615 is a reply to message #127603] Tue, 12 July 2005 09:15 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10752/technique.htm#10796
Re: steps for tuning oracle...! [message #127618 is a reply to message #127615] Tue, 12 July 2005 09:21 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Hi Martin

The link given is really cool one.... Provides straight forward insight in dealing with performance issues

Regds
Girish
Re: steps for tuning oracle...! [message #127639 is a reply to message #127603] Tue, 12 July 2005 11:23 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Yeah, their 10g performance tuning book is an all around good one, to me it is much improved over all previous versions. Definitely worth the time for everyone to read that one cover to cover. I need to check out the 10gR2 version.

It also pretty explicitly moves away from the DKB / Ault approach and embraces the Kyte / Millsap approach.
Previous Topic: Regarding CPU utilization
Next Topic: wait events
Goto Forum:
  


Current Time: Thu Apr 18 22:27:25 CDT 2024