[20171109]查看隐含参数脚本.txt
--//查看隐含参数的脚本,今天没事修改一下增加查询description字段的内容.也有网友要求提供这个脚本,实际上这些脚本都是自己工作
--//中不断收集整理.网上许多地方都能找到.
$ cat hide.sql
col name format a40
col description format a66
col session_value format a22
col default_value format a22
col system_value format a22
select
a.ksppinm name,
a.ksppdesc DESCRIPTION,
b.ksppstdf DEFAULT_VALUE,
b.ksppstvl SESSION_VALUE,
c.ksppstvl SYSTEM_VALUE
from x$ksppi a, x$ksppcv b, x$ksppsv c
where a.indx = b.indx
and a.indx = c.indx
and lower(a.ksppinm) like lower('%&1%')
order by 1;
--//修改如下:
col name format a40
col description format a66
col session_value format a22
col default_value format a22
col system_value format a22
select
a.ksppinm name,
a.ksppdesc DESCRIPTION,
b.ksppstdf DEFAULT_VALUE,
b.ksppstvl SESSION_VALUE,
c.ksppstvl SYSTEM_VALUE
from x$ksppi a, x$ksppcv b, x$ksppsv c
where a.indx = b.indx
and a.indx = c.indx
and lower(a.ksppinm) like lower('%&1%')
order by 1;
$ cat hidex.sql
col name format a40
col description format a66
col session_value format a22
col default_value format a22
col system_value format a22
select
a.ksppinm name,
a.ksppdesc DESCRIPTION,
b.ksppstdf DEFAULT_VALUE,
b.ksppstvl SESSION_VALUE,
c.ksppstvl SYSTEM_VALUE
from x$ksppi a, x$ksppcv b, x$ksppsv c
where a.indx = b.indx
and a.indx = c.indx
and (lower(a.ksppinm) like lower('%&1%') or lower(a.ksppdesc ) like lower('%&1%'))
--//顺便测试看看,必须以sys用户执行:
SYS@book> @ &r/ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
SYS@book> @ &r/hidex _allow%corr%
old 10: and (lower(a.ksppinm) like lower('%&1%') or lower(a.ksppdesc ) like lower('%&1%'))
new 10: and (lower(a.ksppinm) like lower('%_allow%corr%%') or lower(a.ksppdesc ) like lower('%_allow%corr%%'))
NAME DESCRIPTION DEFAULT_VALUE SESSION_VALUE SYSTEM_VALUE
---------------------------------------- ------------------------------------------------------------------ ------------- ------------- ------------
_allow_read_only_corruption allow read-only open even if database is corrupt TRUE FALSE FALSE
_allow_resetlogs_corruption allow resetlogs even if it will cause corruption TRUE FALSE FALSE
_allow_terminal_recovery_corruption Finish terminal recovery even if it may cause corruption TRUE FALSE FALSE
_kdli_allow_corrupt allow corrupt filesystem_logging data blocks during read/write TRUE TRUE TRUE
--//^_^,发现一个_allow_read_only_corruption,感觉异常关闭,设置这个参数可以只读打开,明天测试看看.