How Does oracle set show parameter to display implicit parameters?

How to Set show parameter to display implicit parameters in oracle? show parameter in sqlplus does not show hidden parameters. You need to handle this as follows: Log On As a sys User:

C:\Documents and Settings\guogang>sqlplus / as sysdba;SQL> create or replace view 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);   SQL> grant select on my_v$parameter_with_hidden to test;

 

Log on as a common user:

C:\Documents and Settings\guogang>sqlplus test/testSQL> create synonym v$parameter for sys.my_v$parameter_with_hidden ;SQL> show parameter  _small_table_thresholdNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------_small_table_threshold               integer     798