Note:Changing the value of oracle hidden parameters without contacting oracle support would result in unsupported database by ORACLE.
col value format a10
col parameter format a30
set lines 100 pages 0
select a.ksppinm "Parameter",
c.ksppstvl "Value" from x$ksppi a,x$ksppsv c
where a.indx =c.indx
and a.ksppinm like '/_push%' escape '/';( You can substitute the ksppinm value with parameter name you want to view the value for)
No comments:
Post a Comment