Re: Unable to shrink shared_pool in CDB in 19.14

Hello Jeffrey,
what's the granule size?

SQL> select bytes from v$sgainfo where name like 'Granule Size';

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org> hat am 11.05.2022 18:06 geschrieben:
>
>
> 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>@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