Database Administration (MOSC)

MOSC Banner

Conflicting information on Memory Management?

edited May 12, 2014 11:07AM in Database Administration (MOSC) 5 commentsAnswered ✓

Running Oracle RDBMS 11.2.0.3 on RHEL x86-64, without ASM.  I thought I had a good understanding of Automatic Memory Management and Automatic Shared Memory Manaagement until I read the "High Availability Best Practices" document which reads as follows:

 

4.4.2 Use Automatic Shared Memory Management with SGA_TARGET and PGA_

AGGREGATE_TARGET Parameters

 

Use the SGA_TARGET and PGA_AGGREGATE_TARGET initialization parameters in

the Oracle ASM instance to manage ASM process memory using the automatic shared

memory management (ASSM) functionality.

To use automatic shared memory management the values for MEMORY_TARGET and

MEMORY_MAX_TARGET should be set to 0.

Is ASM that much different? 

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