Shulou(Shulou.com)06/01 Report--

Modification and viewing of oracle implied parameters

Alter system set "_ allow_resetlogs_corruption" = false scope=spfile sid='*'

Col name for a30

Col value for a10

Select

X.ksppinm name

Y.ksppstvl value

Y.ksppstdf isdefault

Decode (bitand (y.ksppstvfMagne7), 1memorialMODIFIED playbook page4 ismod

Decode (bitand (y.ksppstvfMagne2), 2 isadj

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 ='_ allow_resetlogs_corruption'

Order by

Translate (x.ksppinm,'_','')

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.