Showing posts with label Hidden Parameter Script in Oracle. Show all posts
Showing posts with label Hidden Parameter Script in Oracle. Show all posts

Script to Find Hidden Parameters in Oracle

SELECT
  x.ksppinm name,
  y.ksppstvl VALUE,
  decode(ksppity,
    1,   'BOOLEAN',
    2,   'STRING',
    3,   'INTEGER',
    4,   'PARAMETER FILE',
    5,   'RESERVED',
    6,   'BIG INTEGER',
    'UNKNOWN') typ,