Database Memory & 4030/4031 (MOSC)

MOSC Banner

Modified db_cache_size parameter from 1400M to 1664M. But, Shared IO Pool is eating 112M memory from

edited Jul 27, 2019 5:05AM in Database Memory & 4030/4031 (MOSC) 3 commentsAnswered

Hi Team MOSC,

Recently I have modified db_cache_size parameter from 1400M to 1664M.

but, Shared IO Pool is eating 112M memory from buffer cache.

From alertlog(Shared IO Pool defaulting to 112MB. Trying to get it from Buffer Cache for process 30479)

process 30479 is happens to be [mmon]

SQL> SELECT * FROM v$sgainfo;

NAME                                     BYTES RES     CON_ID

-------------------------------- ------------- --- ----------

Fixed SGA Size                         8626048 No           0

Redo Buffers                           8151040 No           0

Buffer Cache Size                   1744830464 Yes          0     i.e. 1664M

In-Memory Area Size                          0 No           0

Shared Pool Size                    1476395008 Yes          0

Large Pool Size                       16777216 Yes          0

Java Pool Size                        16777216 Yes          0

Streams Pool Size                     33554432 Yes          0

Shared IO Pool Size                  117440512 Yes          0     i.e. 112M

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