sorting error

[ales]

The hidden parameters aren't visible in the v$parameter view and this is why the "show parameter" doesn't work. Try this query, works for me. You have to be logged as sys.

select
   a.ksppinm name,
   b.ksppstvl value,
   b.ksppstdf deflt,
   decode
   (a.ksppity, 1,
   'boolean', 2,
   'string', 3,
   'number', 4,
   'file', a.ksppity) type,
   a.ksppdesc description
from
   sys.x$ksppi a,
   sys.x$ksppcv b
where
   a.indx = b.indx
and
   a.ksppinm = '&parameter_name'
/

[mahajanakhil198]

well i got it now..thanks

[mahajanakhil198]

@ ales and PAVB, i got sth to add to ur discussion..
though its only another discussion forum n not a credible source..
http://www.oracle-base.com/forums/vi...st=0&sk=t&sd=a