[Oracle Script] latch holder
select PID , SID , LADDR , NAME , GETS from GV$LATCHHOLDER where inst_id = USERENV('Instance')
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-2143819/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [Oracle Script] check latchOracle
- Oracle Latch及latch衝突Oracle
- oracle scriptOracle
- Oracle Latch & LockOracle
- Oracle KSL Latch 管理層 與 Latch管理Oracle
- [Oracle Script] LockOracle
- Oracle Database ScriptOracleDatabase
- ORACLE LOCK,LATCH,PINOracle
- Oracle Latch 說明Oracle
- oracle latch優化Oracle優化
- oracle 11g latch之v$latch系列二Oracle
- oracle 11g latch之v$latch系列三Oracle
- ORACLE鎖存器(LATCH)Oracle
- [Oracle Script] Top sqlOracleSQL
- [Oracle Script] check userOracle
- Oracle kill session scriptOracleSession
- ORACLE常用Script(轉)Oracle
- ORACLE常用Script (轉)Oracle
- Oracle中的redo copy latchOracle
- [Oracle Script] check active sessionOracleSession
- [Oracle Script] Log switch statusOracle
- [Oracle Script] check lock infoOracle
- [Oracle Script] Temporary Sort UsageOracle
- [Oracle Script] Rollback Segment UsageOracle
- [Oracle Script] check Literal SQLOracleSQL
- 查詢holder的操作
- Systematic Latch Contention Troubleshooting in OracleOracle
- Oracle效能優化--Latch介紹Oracle優化
- 深入理解Oracle中的latchOracle
- oracle latch_自譯文_(1)Oracle
- oracle latch_自譯文_(2)Oracle
- oracle latch_自譯文_(3)Oracle
- [Oracle Script] check tablespace usage infoOracle
- [Oracle Script] select db parameterOracle
- [Oracle Script] check temp tablespace usageOracle
- [Oracle Script] ASM Disks Performance metricOracleASMORM
- [Oracle Script] Undo Usage Per statusOracle
- [Oracle Script] Undo Usage Per sessionOracleSession