To Check the Hidden parameter in oracle database

SET PAGESIZE 60
SET LINESIZE 300

COLUMN ksppinm FORMAT A50
COLUMN ksppstvl FORMAT A50

SELECT
  ksppinm,
  ksppstvl
FROM
  x$ksppi a,
  x$ksppsv b
WHERE
  a.indx=b.indx
AND
  substr(ksppinm,1,1) = ‘_’
AND ksppinm like ‘%<hidden parameter name>%’
ORDER BY ksppinm
/

  • January 7, 2016 | 15 views
  • Comments