oracle查看sga实际使用,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.