Home » RDBMS Server » Server Administration » Suggestions for 16GB Ram
Suggestions for 16GB Ram [message #174382] Mon, 29 May 2006 00:45 Go to next message
hafeezs
Messages: 8
Registered: May 2006
Location: islamabad
Junior Member
Dear friends,

We have purchased new Ram of 16GB for our Database. I need your suggesstions for memory parameter to be set for new Ram for effective use.

Before we had 4GB Ram.

We have Oracle 10G on Solaris 9.

Hafeez

Report message to a moderator

Re: Suggestions for 16GB Ram [message #174441 is a reply to message #174382] Mon, 29 May 2006 04:32 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Just start using it.

For starters, increase your SGA_MAX_SIZE, SGA_TARGET and PGA_AGGREGATE_TARGET parameters. After that monitor utilization to see if further tuning is required.

Report message to a moderator

Previous Topic: Urgent
Next Topic: Analyze Database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:22:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.