[Oracle Script] select db parameter
#查詢隱藏引數
set linesize 160
col ksppinm format a40
col ksppstvl format a30
col ksppdesc format a190
SELECT ksppinm, ksppstvl, ksppdesc
FROM x$ksppi x, x$ksppcv y
WHERE x.indx = y.indx
AND ksppinm like '%&value%';
or
select (select instance_name from v$instance where instance_number=userenv('instance')) instance_name,
ksppinm name,
ksppstvl value,
ksppstdf ISDEFAULT,
decode(bitand(ksppstvf,7), 1, 'MODIFIED', 4, 'SYSTEM_MOD', 'FALSE') Changed,
decode(bitand(ksppiflg/65536,3), 1, 'IMMEDIATE', 2, 'DEFERRED', 3, 'IMMEDIATE', ' ') SYS_Modify ,
decode(bitand(ksppiflg /256,1), 1, 'TRUE', 'FALSE') SESSION_Modify,
ksppdesc DESCRIPTION
from sys.xm$ksppi x, sys.xm$ksppsv y
where x.indx = y.indx
AND x.inst_id = y.inst_id
and x.inst_id=userenv('INSTANCE')
order by ksppinm;
set linesize 160
col ksppinm format a40
col ksppstvl format a30
col ksppdesc format a190
SELECT ksppinm, ksppstvl, ksppdesc
FROM x$ksppi x, x$ksppcv y
WHERE x.indx = y.indx
AND ksppinm like '%&value%';
or
select (select instance_name from v$instance where instance_number=userenv('instance')) instance_name,
ksppinm name,
ksppstvl value,
ksppstdf ISDEFAULT,
decode(bitand(ksppstvf,7), 1, 'MODIFIED', 4, 'SYSTEM_MOD', 'FALSE') Changed,
decode(bitand(ksppiflg/65536,3), 1, 'IMMEDIATE', 2, 'DEFERRED', 3, 'IMMEDIATE', ' ') SYS_Modify ,
decode(bitand(ksppiflg /256,1), 1, 'TRUE', 'FALSE') SESSION_Modify,
ksppdesc DESCRIPTION
from sys.xm$ksppi x, sys.xm$ksppsv y
where x.indx = y.indx
AND x.inst_id = y.inst_id
and x.inst_id=userenv('INSTANCE')
order by ksppinm;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-2141488/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 10gR2 dataguard db_unique_name parameterOracle 10g
- DB_NAME Initialization Parameter (87)
- DB_DOMAIN Initialization Parameter (88)AI
- 關於Oracle DB中SQL Script的註釋(REM,--,/* */)OracleSQLREM
- Oracle ParameterOracle
- DB_BLOCK_SIZE Initialization Parameter (92)BloC
- Initianization Parameter (1) : DB_BLOCK_SIZEBloC
- Initianization Parameter (2) : DB_BLOCK_BUFFERSBloC
- Initianization Parameter (3) : DB_CACHE_SIZE
- oracle scriptOracle
- DB_CACHE_SIZE Initialization Parameter (109)
- linux_db_script ---014Linux
- Oracle Server Parameter FilesOracleServer
- [Oracle Script] LockOracle
- Oracle Database ScriptOracleDatabase
- DB中備份每一張table script
- [Oracle Script] Top sqlOracleSQL
- [Oracle Script] check userOracle
- [Oracle Script] check latchOracle
- Oracle kill session scriptOracleSession
- ORACLE常用Script(轉)Oracle
- ORACLE常用Script (轉)Oracle
- Procwatcher: Script to Monitor and Examine DB and Clusterware Pro-459694.1
- oracle實驗記錄 (oracle reset parameter)Oracle
- [Oracle Script] check active sessionOracleSession
- [Oracle Script] Log switch statusOracle
- [Oracle Script] check lock infoOracle
- [Oracle Script] latch holderOracle
- [Oracle Script] Temporary Sort UsageOracle
- [Oracle Script] Rollback Segment UsageOracle
- [Oracle Script] check Literal SQLOracleSQL
- (轉):學習Oracle動態效能表-(17)-v$parameter & v$system_parameterOracle
- Oracle table selectOracle
- oracle select for updateOracle
- [Oracle Script] check tablespace usage infoOracle
- [Oracle Script] check temp tablespace usageOracle
- [Oracle Script] ASM Disks Performance metricOracleASMORM
- [Oracle Script] Undo Usage Per statusOracle