Database Memory & 4030/4031 (MOSC)

MOSC Banner

Consult for Oracle Memory Config

edited Mar 9, 2022 8:32AM in Database Memory & 4030/4031 (MOSC) 11 commentsAnswered ✓

Hi everybody,

I need the consult for Oracle memory config.

Server 2008 R2

Oracle Standard 11.2.0.1

The memory Server is 32GB

Currently my memory config is as follows:

SGA Usage:

PGA Usage

As you can see that:

SGA target is set fixed to 21GB and used 19GB

PGA target is set fixed to 6B and used 312 MB.

Memory Target is set fixed to 28GB

When I check the process oracle in task manager, it consumes 21GB Memory.

Check recommend memory_target

As you can see current memory_target is 26GB, and Oracle recommend I should change to 16GB so that performance is still the same and I can utilize my memory?

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