Database Tuning (MOSC)

MOSC Banner

Undersized instance memory

edited May 10, 2010 3:16AM in Database Tuning (MOSC) 5 commentsAnswered
 

Hi,

From ADDM report i got the advise to increase my memory from 14 G to 17 G. Please advice can i go for that change.

Herewith I am uploading ADDM suggestion and AWR report.

Thanks in advance

My DB Details:

OS : AIX 6.1

DB : Oracle 11g R1 (11.1.0.7)

Storage : SAN (ASM Raw File System)

Finding 2: Undersized instance memory
Impact is .11 active sessions, 99.83% of total activity.
--------------------------------------------------------
The Oracle instance memory (SGA and PGA) was inadequately sized, causing
additional I/O and CPU usage.
The value of parameter "memory_target" was "14336 M" during the analysis
period.

Recommendation 1: Database Configuration
Estimated benefit is .11 active sessions, 99.83% of total activity.

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