select i.ksppinm name,
i.ksppdesc description,
cv.ksppstvl value,
cv.ksppstdf isdefault,
decode(bitand(cv.ksppstvf, 7),
1,
'MODIFIED',
4,
'SYSTEM_MOD',
'FALSE') ismodified,
decode(bitand(cv.ksppstvf, 2), 2, 'TRUE', 'FALSE') isadjusted
from sys.x$ksppi i, sys.x$ksppcv cv
where i.inst_id = userenv('Instance')
and cv.inst_id = userenv('Instance')
and i.indx = cv.indx
and i.ksppinm like '/_%' escape '/'
order by replace(i.ksppinm, '_', '');
查看oracle 隐藏参数
最新推荐文章于 2024-09-24 11:36:02 发布