set lines 200 pages 55
col KSPPINM format a25
col KSPPSTVL format a22
select a.ksppinm, b.ksppstvl
from sys.x$ksppi a, sys.x$ksppcv b
where a.indx = b.indx
and a.ksppinm like '_ash%';
KSPPINM KSPPSTVL
------------------------- ----------------------
hash_area_size 131072
_ash_sampling_interval 1000
_ash_size 1048618
_ash_enable TRUE
_ash_disk_write_enable TRUE
_ash_disk_filter_ratio 10
_ash_eflush_trigger 66
_ash_sample_all FALSE
_ash_dummy_test_param 0
_ash_min_mmnl_dump 90
_ash_compression_enable TRUE
11 rows selected.
_ash_sampling_interval 1000ms 采样一次 其中
_ash_sample_all 设置成true,会把inactive的session也进ash中，如果开则个参数,不多就sysaux表空间就会满,轻易不要改这个参数
{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.xiaopingtou.cn//data/attach/topic/topicKPo7gB.jpg', '推荐 llinnux 的文章《dba_hist_active_sess_history中sample_time的采样时间》','https://www.xiaopingtou.net/article-82348.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}