Script- To find out ASM Hidden Parameters

[shailesh_dba]

Hi Friends,

How to find out ASM Hidden Parameters? This query raised in every Oracle DBA's mind. Here is script to obtain hidden parameters of ASM. It is just like Oracle's hidden parameter query only thing you need to put ASM in like operator.

Code: Select all

SELECT x.ksppinm name, y.ksppstvl value, x.ksppdesc description
FROM x$ksppi x, x$ksppcv y
WHERE x.inst id = userenv('Instance')
AND y.inst id = userenv('Instance')
AND x.indx = y.indx
AND x.ksppinm LIKE '\ asm%' ESCAPE '\'
ORDER BY name;

Thanks,
Shailesh the DBA

[mehul80454]

Hi Shailesh,

Thanks for nice contribution. Appreciate help.