top of page
Search

Is OMF enabled in your Oracle Database 12c and 19c


col name format a25 col value format a10 select a.ksppinm name, b.kspftctxvl value, b.kspftctxdf isdefault, decode(bitand(b.kspftctxvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE') ismod, decode(bitand(b.kspftctxvf,2),2,'TRUE','FALSE') isadj from sys.x$ksppi a, sys.x$ksppcv2 b where a.inst_id = userenv('Instance') and b.inst_id = userenv('Instance') and a.indx+1 = b.kspftctxpn and a.ksppinm like '%omf%' ;



21 views0 comments

Recent Posts

See All

Comments


Contact Me

Tel: 7989359581

Lakshminarayana0071@gmail.com

  • Facebook Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon

Thanks for submitting!

© 2023 by Phil Steer . Proudly created with Wix.com

bottom of page