| SGA PGA Tuning [message #65289] |
Fri, 23 July 2004 02:31  |
agoodwin
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:-
SGA RAM 65%
PGA RAM 15%
UNIX RAM 20% (although I am running Windows 2000 OS)
We are running an OLTP based system 9.2.0.4 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  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
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.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
