-- Initialization parameters
SELECT p.name,
       p.display_value,
       DECODE(p.isdefault,'TRUE','YES','FALSE','NO') default_value,
       DECODE(p.isses_modifiable,'IMMEDIATE','YES','FALSE','NO','DEFERRED','NO','YES') session_modifiable,
       DECODE(p.issys_modifiable,'IMMEDIATE','YES','FALSE','NO','DEFERRED','NO','YES') system_modifiable,
       p.description
 FROM  v$parameter p
 ORDER BY p.name;