转载请注明出处:http://blog.csdn.net/guoyjoe/article/details/51447005
一、用sys用户登录创建视图:show_hidden_parameter
sys@ZJEDU>conn / as sysdba
sys@ZJEDU>create or replace view show_hidden_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)
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
from x$ksppi x, x$ksppcv y
where (x.indx = y.indx);
sys@ZJEDU> grant select on show_hidden_parameter to gyj;
Grant succeeded.
三、创建同义词v$parameter
sys@ZJEDU> conn gyj/gyjConnected.
gyj@ZJEDU> create synonym v$parameter for sys.show_hidden_parameter;
Synonym created.
四、查控制文件相关的隐含参数
gyj@ZJEDU> conn gyj/gyjConnected.
gyj@ZJEDU> show parameter controlfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_controlfile_autobackup_delay integer 300
_controlfile_backup_copy_check boolean TRUE
_controlfile_block_size integer 0
_controlfile_enqueue_dump boolean FALSE
_controlfile_enqueue_holding_time integer 120
_controlfile_enqueue_holding_time_tr integer 10
acking_size
_controlfile_enqueue_timeout integer 900
_controlfile_section_init_size integer
_controlfile_section_max_expand integer
_controlfile_update_check string OFF
_flashback_validate_controlfile boolean FALSE
_imr_controlfile_access_wait_time integer 10
_kill_controlfile_enqueue_blocker boolean TRUE