oracle官网下载账号oracle如何设置show parameter显示隐含参数

oracle如何设置show parameter显示隐含参数

   在sqlplus中show parameter是显示不了隐藏参数的，需要做一个处理，如下所示：

   以SYS用户登录：

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;

     以普通用户登录：

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----oracle账号-------------------------------- ----------- ------------------------------_small_table_threshold               integer     798