oracle 查看SGA中各个组件的实际使用大小的脚本

set linesize 100
col name for a25
col value for a15
col describ for a40
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%'
/
16:39:14 sys@stldb> /
Enter value for par: shared_pool
old   6:   and x.ksppinm like '%&par%'
new   6:   and x.ksppinm like '%shared_pool%'

NAME                      VALUE           DESCRIB
------------------------- --------------- ----------------------------------------
_enable_shared_pool_durat TRUE            temporary to disable/enable kgh policy
ions

__shared_pool_size        6979321856      Actual size in bytes of shared pool
shared_pool_size          0               size in bytes of shared pool
shared_pool_reserved_size 328833433       size in bytes of reserved area of shared
                                           pool

_shared_pool_reserved_pct 5               percentage memory of the shared pool all
                                          ocated for the reserved area

_shared_pool_reserved_min 4400            minimum allocation size in bytes for res
_alloc                                    erved area of shared pool

_io_shared_pool_size      4194304         Size of I/O buffer pool from SGA
_shared_pool_max_size     0               shared pool maximum size when auto SGA e
                                          nabled

_shared_pool_minsize_on   FALSE           shared pool minimum size when auto SGA e
                                          nabled

_dm_max_shared_pool_pct   1               max percentage of the shared pool to use
                                           for a mining model


10 rows selected.