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

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;