HIDDEN PARAMETER OF OUR DB

Some time we required to find the hidden parameter of our database  you can fine the hidden parameters using below  statement



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 LIKE '\_%' ESCAPE '\' and a.ksppinm like '%&name%'
To change the hidden parameter you need to specify then in double qoutes
 alter system set "_max_io_size"=4194304;
/