Modified db_cache_size parameter from 1400M to 1664M. But, Shared IO Pool is eating 112M memory from
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