Database Administration (MOSC)

MOSC Banner

can not shrink shared pool in 19.14

Over increased the shared pool in a CDB. Altered the shared pool from 2400m to 2300m to shrink it. Did not shrink so restarted CDB. After restart CDB, shared pool still shows as 2400m per below. Alert log shows 2300m in the list of startup parameters. I know this is a minor change but asking in the event ever had to do a larger change.


SYSTEM@cdb01t06>@sga_components


current min

COMPONENT size M size M LAST_OPER_TYP GRANULE_SIZE_M

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

shared pool 2400 2400 STATIC 16

large pool 16 16 STATIC 16

java pool 64 64 STATIC 16

streams pool 48 48 STATIC 16

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