IT运维管理体系和规范,it运维管理系统介绍
596
2022-10-10
隐含参数_MAX_CR_ROLLBACKS
_MAX_CR_ROLLBACKS隐含参数的作用,以及使用场景。
--查看_MAX_CR_ROLLBACKS隐藏参数--当前环境为11.2.0.3SQL> set pagesize 2000SQL> col name for a50SQL> col description for a100SQL> col value for a10SQL> SELECT i.ksppinm name, 2 i.ksppdesc description, 3 CV.ksppstvl VALUE, 4 CV.ksppstdf isdefault, 5 DECODE (BITAND (CV.ksppstvf, 7), 6 1, 'MODIFIED', 7 4, 'SYSTEM_MOD', 8 'FALSE') 9 ismodified, 10 DECODE (BITAND (CV.ksppstvf, 2), 2, 'TRUE', 'FALSE') isadjusted 11 FROM sys.x$ksppi i, sys.x$ksppcv CV 12 WHERE i.inst_id = USERENV ('Instance') 13 AND CV.inst_id = USERENV ('Instance') 14 AND i.indx = CV.indx 15 AND i.ksppinm=lower('_MAX_CR_ROLLBACKS') ; NAME DESCRIPTION VALUE ISDEFAULT ISMODIFIED ISADJ-------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------- --------- ---------- -----_max_cr_rollbacks Maximum number of CR rollbacks per block (LMS) 0 TRUE FALSE FALSE --10.2.0.4SQL> set pagesize 2000SQL> col name for a50SQL> col value for a10SQL> SELECT x.ksppinm NAME, y.ksppstvl VALUE 2 FROM SYS.x$ksppi x, SYS.x$ksppcv y 3 where x.indx = y.indx 4 AND x.ksppinm =lower('_MAX_CR_ROLLBACKS'); no rows selected --11.2.0.4SQL> set pagesize 2000SQL> col name for a50SQL> col value for a10SQL> SELECT x.ksppinm NAME, y.ksppstvl VALUE 2 FROM SYS.x$ksppi x, SYS.x$ksppcv y 3 where x.indx = y.indx 4 AND x.ksppinm =lower('_MAX_CR_ROLLBACKS'); NAME VALUE-------------------------------------------------- ----------_max_cr_rollbacks 1000 --12.1.0.2SQL> set pagesize 2000SQL> col name for a50SQL> col value for a10SQL> SELECT x.ksppinm NAME, y.ksppstvl VALUE 2 FROM SYS.x$ksppi x, SYS.x$ksppcv y 3 where x.indx = y.indx 4 AND x.ksppinm =lower('_MAX_CR_ROLLBACKS'); NAME VALUE-------------------------------------------------- ----------_max_cr_rollbacks 1000 --18cSQL> set pagesize 2000SQL> col name for a50SQL> col value for a10SQL> SELECT x.ksppinm NAME, y.ksppstvl VALUE 2 FROM SYS.x$ksppi x, SYS.x$ksppcv y 3 where x.indx = y.indx 4 AND x.ksppinm =lower('_MAX_CR_ROLLBACKS'); NAME VALUE-------------------------------------------------- ----------_max_cr_rollbacks 1000
发表评论
暂时没有评论,来抢沙发吧~