test-scn-10g

col name for a30;col value for a10;selectx.ksppinm  name,y.ksppstvl  value,y.ksppstdf  isdefault,decode(bitand(y.ksppstvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE')  ismod,decode(bitand(y.ksppstvf,2),2,'TRUE','FALSE')  isadjfromsys.x$ksppi x,sys.x$ksppcv ywherex.inst_id = userenv('Instance') andy.inst_id = userenv('Instance') andx.indx = y.indx and x.ksppinm ='_max_reasonable_scn_rate'order bytranslate(x.ksppinm, ' _', ' ')/