SLTechnology News&Howtos › Database ›

Modification and viewing of oracle implied parameters

Shulou Source: shulou.com Published: 2022-06-01 13:32:16 10月02日 Update

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,'_','')