1. Create a View Show_hidden_v$parameter
Create or Replace view Show_hidden_v$parameter (inst_id, NUM, NAME, TYPE, VALUE, Display_value, ISDEFAULT, Isses_mod Ifiable, Issys_modifiable, isinstance_modifiable, ismodified, isadjusted, isdeprecated, DESCRIPTION, UPDATE_COMMENT , HASH) as Select x.inst_id, X.indx + 1, ksppinm, ksppity, KSPPSTVL, KSPPSTDVL, KSPPSTDF, Decode (Bitand (ksppiflg/256, 1), 1, ' TRUE ', ' FALSE '), Decode (Bitand (KSPP iflg/65536, 3), 1, ' IMMEDIATE ', 2, ' DEFERRED ', 3, ' IMMEDIATE ', ' FALSE '), Decode (Bitand (KSPPIFLG, 4), 4, ' False ', decode (Bitand (ksppiflg/65536, 3), 0, ' false ', ' TRUE ')), Decode (KSP PSTVF, 7), 1, ' MODIFIED ', 4, ' System_mod ', ' false '), Decode (Bitand (KSPPSTVF, 2), 2, ' TRUE ', ' false '), DE Code (Bitand (KSPPILRMFLG/1), 1, ' TRUE ', ' FALSE '), Ksppdesc, Ksppstcmnt, Ksppihash from X$ksppi x, X$KSPPCV y WHERE (x.indx = y.indx);
2. Authorize
Sql> Grant SELECT on Show_hidden_v$parameter to Scott; Sql> conn scott/tigersql> create synonym v$parameter for sys.show_hidden_v$parameter; Sql> Show Parameter latch
Let show parameter Show hidden parameters (11G)