Oracle Hidden Parameters
SELECT
a.ksppinm "Parameter",
b.ksppstvl "Session Value",
c.ksppstvl "Instance Value"
FROM
x$ksppi a,
x$ksppcv b,
x$ksppsv c
WHERE
a.indx = b.indx
AND
a.indx = c.indx
AND
a.ksppinm LIKE '/_%' escape '/'[@more@]
a.ksppinm "Parameter",
b.ksppstvl "Session Value",
c.ksppstvl "Instance Value"
FROM
x$ksppi a,
x$ksppcv b,
x$ksppsv c
WHERE
a.indx = b.indx
AND
a.indx = c.indx
AND
a.ksppinm LIKE '/_%' escape '/'[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9907339/viewspace-1047639/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle11g Hidden Parameters | PERUMAL.ORGOracle
- How To Change The Oracle Hidden Parameters In Oracle 10g [ID 315631.1]Oracle 10g
- script--by Steve Adams--hidden_parameters.sqlSQL
- Oracle Parallel ParametersOracleParallel
- Unix kernel parameters for OracleOracle
- Oracle cascading standby ParametersOracle
- JVM parametersJVM
- v$nls_parameters和nls_database_parametersDatabase
- jQuery :hiddenjQuery
- 獲取_字首的oracle hidden parameter隱含引數Oracle
- 如何不使用 overflow: hidden 實現 overflow: hidden
- Hidden Bipartite Graph
- Oracle OCP 1Z0 053 Q465(NLS Parameters)Oracle
- Oracle OCP 1Z0-053 Q173(ASM Parameters)OracleASM
- TypeError: object() takes no parametersErrorObject
- HTML hidden屬性HTML
- Understanding Initialization Parameters (85)
- Other SGA Initialization Parameters (96)
- Globalization Support Parameters in Views (178)View
- 相容所有瀏覽器overflow-x:hidden或者overflow-y:hidden瀏覽器
- File hash GET parameters for Django staticfilesDjango
- How to Change RabbitMQ Queue Parameters in Production?MQ
- HTML input hidden隱藏域HTML
- HTML input hidden 隱藏域HTML
- SAP Spartacus 中的 HTTP URL parametersHTTP
- The Builder pattern simulates named optional parameters(Java)UIJava
- User defined table type and table valued parameters
- Android Audio HAL 介面介紹之 adev_set_parameters()和out_set_parameters()Androiddev
- overflow:hidden,auto什麼區別
- oracle 11g show parameter顯示隱含引數hidden parameter_x$ksppiOracle
- hidden, opaque, alpha, opacity的區別Opaque
- Deformity JSP Webshell、Webshell Hidden LearningORMMITJSWebshell
- aria-hidden="true"有什麼用
- Python中小錯誤 之 object() takes no parametersPythonObject
- Parameter index out of range (3 > number of parameters, which is 2).Index
- Setting the Buffer Cache Initialization Parameters (108)
- c++ 模板模板引數("Template Template Parameters")C++
- How To Enable Hidden Administrator Account In Windows 10Windows