让show parameter显示隐含参数(12C)

1.创建视图show_hidden_v$parameter

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34

create or replace view show_hidden_v$parameter                                                                                       (inst_id,NUM , NAME , TYPE , VALUE , DISPLAY_VALUE, ISDEFAULT , ISSES_MODIFIABLE , ISSYS_MODIFIABLE , ISPDB_MODIFIABLE , ISINSTANCE_MODIFIABLE, ISMODIFIED , ISADJUSTED , ISDEPRECATED, ISBASIC, DESCRIPTION, UPDATE_COMMENT, HASH, CON_ID) as       select x.inst_id,        x.indx + 1,        ksppinm,        ksppity,        ksppstvl,        ksppstdvl,        ksppstdf,        decode(bitand(ksppiflg / 256, 1), 1, 'TRUE', 'FALSE'),        decode(bitand(ksppiflg / 65536, 3),               1,               'IMMEDIATE',               2,               'DEFERRED',               3,               'IMMEDIATE',               'FALSE'),        decode(bitand(ksppiflg / 524288, 1), 1, 'TRUE', 'FALSE'),        decode(bitand(ksppiflg, 4),               4,               'FALSE',               decode(bitand(ksppiflg / 65536, 3), 0, 'FALSE', 'TRUE')),        decode(bitand(ksppstvf, 7), 1, 'MODIFIED', 4, 'SYSTEM_MOD', 'FALSE'),        decode(bitand(ksppstvf, 2), 2, 'TRUE', 'FALSE'),        decode(bitand(ksppilrmflg / 64, 1), 1, 'TRUE', 'FALSE'),        decode(bitand(ksppilrmflg / 268435456, 1), 1, 'TRUE', 'FALSE'),        ksppdesc,        ksppstcmnt,        ksppihash,        x.con_id   from x$ksppi x, x$ksppcv y  where (x.indx = y.indx);

2.授权一下

?

1 2 3

SQL> grant select on show_hidden_v$parameter to C##YB; SQL> conn C##YB/YB SQL> create synonym v$parameter for sys.show_hidden_v$parameter;