Unable to shrink shared_pool in CDB in 19.14
Date: Wed, 11 May 2022 16:06:46 +0000
Message-ID: <DM6PR09MB4677A68EF0E2AE85139F0581DFC89_at_DM6PR09MB4677.namprd09.prod.outlook.com>
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_at_cdb01t06>_at_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
unified pga pool 0 0 STATIC 16
memoptimize buffer cache 0 0 STATIC 16
DEFAULT buffer cache 1680 1680 INITIALIZING 16
KEEP buffer cache 0 0 STATIC 16
RECYCLE buffer cache 0 0 STATIC 16
DEFAULT 2K buffer cache 0 0 STATIC 16
DEFAULT 4K buffer cache 0 0 STATIC 16
DEFAULT 8K buffer cache 0 0 STATIC 16
DEFAULT 16K buffer cache 0 0 STATIC 16
DEFAULT 32K buffer cache 0 0 STATIC 16
Shared IO Pool 112 112 STATIC 16
Data Transfer Cache 0 0 STATIC 16
In-Memory Area 0 0 STATIC 16
In Memory RW Extension Ar 0 0 STATIC 16
ea
Jeffrey Beckstrom
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 11 2022 - 18:06:46 CEST