Home » RDBMS Server » Performance Tuning » SGA PGA Tuning
SGA PGA Tuning [message #65289] Fri, 23 July 2004 02:31 Go to next message
Messages: 1
Registered: July 2004
Junior Member
Oracle9i High-Performance Tuning with Statspack (Oracle press book - Don Burleson)recommends the following settings for an OLTP database:-
UNIX RAM 20% (although I am running Windows 2000 OS)
We are running an OLTP based system on Windows 2000 (SP4) with 2G ram and 2G processor, therefore, based on the above recommendations I should set the SGA
and PGA as follows:-
SGA RAM - 1394Meg
PGA RAM -  314Meg
Windows - Remainder
Does this sound correct?
Re: SGA PGA Tuning [message #65296 is a reply to message #65289] Sun, 25 July 2004 08:04 Go to previous message
Frank Naude
Messages: 4578
Registered: April 1998
Senior Member

That should do for the initial setup. Nevertheless, remember to use the memory advisors to tune the various memory areas to perfection:

  • v$db_cache_advice
  • v$shared_pool_advice
  • v$pga_target_advice
  • v$java_pool_advice (Oracle 10g)
  • v$px_buffer_advice (Oracle 10g)

Also monitor memory usage via operating system utilities to ensure the system is not paging or swapping excessively.

Best regards.

Previous Topic: table compress feature of Oracle 9i
Next Topic: Character Set scanner.plz help
Goto Forum:

Current Time: Wed Feb 21 11:52:12 CST 2024