Database Memory & 4030/4031 (MOSC)

MOSC Banner

SGA_TARGET not being honored in Windows 2008 64-bit OS

edited Oct 10, 2018 8:24AM in Database Memory & 4030/4031 (MOSC) 7 commentsAnswered
  Hello,

We are running 10g on a Windows 2008 64-bit server, not in a RAC environment.  It is running at Patch 14.

The server has 16 Gb of RAM.  Our experience in the 32-bit OS has shown us that we need to leave 2GB of RAM for the operating system and the remainder can be given to Oracle as SGA.  In our case  that is 14 GB.  We are seeing in the task manager that the memory working set peak and private are very close to the 16 Gb limit, way over the SGA target of 14 GB set in the spfile.  

Yesterday I ran this sql statement from OEM but it did not change the amount of memory that Oracle is aquiring.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center