Database Memory & 4030/4031 (MOSC)

MOSC Banner

Can we enable ASMM on windows 2003(32-bit) 5GB+ SGA in /PAE mode ?

edited Oct 8, 2009 2:18AM in Database Memory & 4030/4031 (MOSC) 5 commentsAnswered
 Can we enable ASMM on windows 2003(32-bit) 5GB+ SGA in /PAE mode ?

- we have a Windows 2003(enterprise edition) 32 bit server

- It has 7GB of physical RAM

- I have set the /PAE in boot.ini file to overcome the windows 1.7GB
process limitation

- USE_INDIRECT_BUFFERS =TRUE is set

- db_block_buffer is also set ( around 3.4GB)


1) Can enable ASMM feature in the above setup ? if yes how can we ?

2) I guess ASMM feature can be enabled with SGA_TARGET parameter and
right now I can set that because of db_block_buffers.


Any help on how to set a windows 2003(32bit) SGA to 5GB+ SGA with ASMM enabled ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center