Query to check hidden parameters in oracle

 

  
col P_VALUE format a20
col P_NAME format a50

select n.ksppinm p_name, c.ksppstvl p_value from sys.x$ksppi n, sys.x$ksppcv c 
where n.indx=c.indx and lower(n.ksppinm) like lower('\_%') escape '\';