[20171109]檢視隐含參數腳本.txt

[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;

--//修改如下:

$ cat hidex.sql

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,感覺異常關閉,設定這個參數可以隻讀打開,明天測試看看.