1. sysdba登录数据库
[oracle@ufdb165 ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.4.0 Production on Wed Aug 24 15:12:20 2022 Copyright (c) 1982, 2013, Oracle. All rights reserved. SQL> conn /as sysdba
Connected.
SQL> SELECT POOL, SUM(BYTES) / 1024 / 1024 || 'MB' FROM V$SGASTAT WHERE POOL IS NOT NULL GROUP BY POOL;
POOL SUM(BYTES)/1024/1024||'MB'
------------ ------------------------------------------
java pool 448MB
streams pool 128MB
shared pool 4160MB
large pool 1088MB
3. 修改共享池大小
SQL> alter system set shared_pool_size=XXX scope=spfile;
修改后重启数据库生效！
