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%'
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;
/
No comments:
Post a Comment