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.
oracle 查看SGA中各个组件的实际使用大小的脚本
最新推荐文章于 2024-07-13 09:52:51 发布