Database Memory & 4030/4031 (MOSC)

MOSC Banner

About realocate SGA memory

edited Dec 9, 2013 6:47PM in Database Memory & 4030/4031 (MOSC) 4 commentsAnswered ✓
Hi
In our production env, there are two database instances running on one AIX 6.1 server (IBM 550).
Instances names are CFCBO and CFIB. According to the AWR reports and other stats, I have notice followings:

1) SGA use is very low than sga_max allocated
2) Total sga_max_sizes (25G + 12704M) is greater than host memory (32G)
3) Server is running with 30% memory paging.

Please advice me, is there any possibility to reduce sga_max_size of above instances to release memory to OS?


AWR reports details and other stats found

Host mem                                          32G

cfcbo
==============
SGA use                                            16.6G
PGA use                                             1G
%Host Mem used for SGA+PGA        28

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