查看隐含参数脚本

 可以使用如下脚本
SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
FROM SYS.x$ksppi x, SYS.x$ksppcv y
WHERE x.inst_id = USERENV ('Instance')
AND y.inst_id = USERENV ('Instance')
AND x.indx = y.indx
AND x.ksppinm LIKE '%&par%'
/

例如我要查看 _shared_pool_reserved_min_alloc隐含参数

Enter value for par: _shared_pool_reserved_min
old   6: AND x.ksppinm LIKE '%&par%'
new   6: AND x.ksppinm LIKE '%_shared_pool_reserved_min%'

NAME                                VALUE      DESCRIB
----------------------------------- ---------- ------------------------------
_shared_pool_reserved_min_alloc     4100       minimum allocation size in bytes for reserved area of shared pool

修改隐含参数

SQL> alter system set "_shared_pool_reserved_min_alloc"=4400 scope=spfile;

System altered