OraFAQ Forum: Performance Tuning » Configuring the database parameters

Home » RDBMS Server » Performance Tuning » Configuring the database parameters

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

Configuring the database parameters [message #127760]

Wed, 13 July 2005 03:22

hafeez_splendid
Messages: 15
Registered: June 2005
Location: india

Junior Member

hi,
Can anyone tell about the parameters which should be configures to obtain the maximum performance interms of cpu utilization , memory reads, memory writes.

Please suggest any document which can tell about the different values which we can give to those parameters for different type of applications.

Thanx in advance

Report message to a moderator

Re: Configuring the database parameters [message #127819 is a reply to message #127760]

Wed, 13 July 2005 09:13

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/toc.htm

Report message to a moderator

Re: Configuring the database parameters [message #127865 is a reply to message #127819]

Wed, 13 July 2005 15:02

mjschwenger
Messages: 137
Registered: July 2005
Location: US

Senior Member

I would have the same question just check the my own set up.
The link posted is "the BASICS", but we all know that depends on your type of system OLTP, DW, DSS, etc. your parameters could be twiked. I have a high transactional OLTP system.
What will be the parameters I can adjust to obtain higher performance? Something in short , may be...

Report message to a moderator

Re: Configuring the database parameters [message #127980 is a reply to message #127760]

Thu, 14 July 2005 08:10

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

To me, the basics is really all you need for setting most parameters. Actually most parameters you can leave at the default. But if you understand the basics, particularly the memory architecture chapter, then you know enough to set the parameters based on your system. In later versions, oracle will do things for you with parameters such as sga_target and pga_aggregate_target. Just set those and forget it.

The administrators guide also talks about the parameters. And the 10g performance tuning guide has a chapter dedicated to initial configuration of your system which is an excellent read.

But the first step is to understand the basics.

Report message to a moderator

Previous Topic:	Influence of snapshot (STATSPACK) in object locks
Next Topic:	trace level for query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 05:00:57 CDT 2025