Hi all,
DB version is 10.2.0.4. Using AMM. If i do set shared_pool_size. Is that the initial size where the shared pool size cant shrink below that or the shared pool cant grow more than 2.5gb which is set?
SQL> /
COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE USER_SPECIFIED_SIZE OPER_COUNT LAST_OPER_TYP LAST_OPER LAST_OPER GRANULE_SIZE
------------------------------ ------------ ---------- ---------- ------------------- ---------- ------------- --------- --------- ------------
shared pool 2634022912 2634022912 0 2634022912 27 SHRINK DEFERRED 29-SEP-10 16777216
large pool 16777216 16777216 0 0 0 STATIC 16777216
java pool 33554432 33554432 0 0 3 SHRINK DEFERRED 26-SEP-10 16777216
streams pool 16777216 16777216 0 0 1 SHRINK DEFERRED 26-SEP-10 16777216
DEFAULT buffer cache 1.8757E+10 1.8740E+10 0 0 31 GROW DEFERRED 29-SEP-10 16777216
KEEP buffer cache 0 0 0 0 0 STATIC 16777216
RECYCLE buffer cache 0 0 0 0 0 STATIC 16777216
baskar.l