Saturday, September 18, 2010

How to see values for hidden parameters?

select * from (SELECT pin.ksppinm called, pcv.ksppstvl itsvalue
  FROM SYS.x$ksppi pin, SYS.x$ksppcv pcv
 WHERE pin.inst_id = USERENV ('Instance')
   AND pcv.inst_id = pin.inst_id
   AND pin.indx = pcv.indx
   AND pin.ksppinm LIKE '\_%' ESCAPE '\') where upper(called) like
'%OPTI%';

No comments:

Post a Comment