How-to show oracle parameters including hiddened ones
1
2
3
4
5
6
7
8
9
10
| set pagesize 100 set linesize 150 col name format A45 col value format A20 col description format A70 select ksppinm name , ksppstvl value, ksppdesc description from x$ksppi x, x$ksppcv y where (x.indx = y.indx) order by name ; |
Comments
Post a Comment