oracle查看隐藏参数

oracle 如何查看隐藏参数：



createor replaceview my_v$parameter_with_hidden
(NUM,NAME , TYPE, display_Value , ISDEFAULT , ISSES_MODIFIABLE ,
ISSYS_MODIFIABLE ,ISMODIFIED , ISADJUSTED, DESCRIPTION,
UPDATE_COMMENT)
as
select x.indx+1,ksppinm,ksppity,ksppstvl,ksppstdf,
decode(bitand(ksppiflg/256,1),1,'TRUE','FALSE'),
decode(bitand(ksppiflg/65536,3),1,'IMMEDIATE',2,'DEFERRED',
3,'IMMEDIATE','FALSE'), decode(bitand(ksppstvf,7),
1,'MODIFIED',4,'SYSTEM_MOD','FALSE'),
decode(bitand(ksppstvf,2),2,'TRUE','FALSE'),
ksppdesc, ksppstcmnt
from x$ksppi x, x$ksppcv y
where (x.indx = y.indx)
/

View created.

SQL>grant  select on my_v$parameter_with_hidden to  system;

Grant succeeded.

SQL> conn  system
Enter password:
Connected.
SQL>create synonym v$parameter for sys.my_v$parameter_with_hidden;

Synonym created.