Oracle X$ View:X$KJBL
Oracle X$ View:X$KJBL
The status of buffer locks can be checked through the table X$KJBL; it is not necessary to dump the locks with the ORADEBUG command, in order to get to this information. The table contains the client and shadow locks.
Column name Data type Description KJBLLOCKP RAW,kjbl* Lock pointer. Can be joined with X$LE.LE_KJBL. KJBLGRANT VARCHAR2 (9) Current grant level, valid values are: KJUSERNL (0), KJUSERCR (1), KJUSERCW (2), KJUSERPR (3), KJUSERPW (4), KJUSEREX (5) KJBLREQUEST VARCHAR2 (9) Request Level, valid values are: (See KJBLGRANT) KJBLROLE NUMBER Granted Role: KJBL_GRANT_N (0x00), KJBL_GRANT_S (0x01) KJBL_GRANT_X (0x02), KJBL_REQ_S (0x04), KJBL_REQ_X (0x08), KJBL_REQ_STL (0x10), KJBL_REQ_CR (0x10), KJBL_OACK (0x20), KJBL_ROLE_G (0x40), KJBL_HAS_PI (0x80) KJBLRESP RAW, kjbr* Current Resource Info (Resource pointer) KJBLNAME VARCHAR2 (30) Resource name in Hex notation ([id1], [id2], [Type]) KJBLNAME2 VARCHAR2 (30) Resource name in Decimal notation (id1, id2, Type) KJBLQUEUE NUMBER Grant / Convert queue: Grant Queue (0x00), Convert Queue 0x80 KJBLLOCKST VARCHAR2 (64) Lock state: KJUSERGRANTED (0x00), KJUSEROPENING (0x01), KJUSERCLOSING (0x02), KJUSERCANCELLING (0x04), KJUSERCVTING (0x08), KJUSERSTANDALONE (0x10), KJUSERASTDELAYED (0x20), KJUSERMSGPENDING(0x40), KJUSERFROZEN (0x80) KJBLWRITING NUMBER Writing ·0, not writing; 1, writing KJBLREQWRITE Write requested · 0, no request; 1, write requested KJBLOWNER NUMBER Owning instance – node id KJBLMASTER NUMBER Master instance – node id KJBLBLOCKED NUMBER Blocked lock? – Checks if there is a converting lock KJBLBLOCKER NUMBER Blocking lock? - Checks if there is a lock held in an incompatible modeThe columns KJBLBLOCKER and KJBLBLOCKED in particular let you determine if you are waiting on blocked lock or if you are blocking other sessions. With this table, it is also possible to determine where the lock is mastered and the role of the lock.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29446986/viewspace-1184461/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【X$VIEW】X$部分視訊說明View
- Oracle X$TablesOracle
- Oracle X$ TablesOracle
- Oracle:cursor:mutex XOracleMutex
- Oracle內部檢視:X$BH與X$LEOracle
- 常用的Oracle x$ TablesOracle
- Oracle x$table介紹Oracle
- 【轉】oracle X表彙總Oracle
- Cocoa Programming for OS X: View Swapping and Custom Container View ControllersViewAPPAIController
- Oracle X$ table 參考手冊Oracle
- Oracle內部檢視:X$BHOracle
- Oracle's x$ Tables -- René NyffeneggerOracle
- oracle 所有引數資訊x$ksppiOracle
- 檢視Oracle 32位還是64位(x86 or x64)Oracle
- iPhone X和Find X對比評測 OPPO Find X和iPhone X哪個好?iPhone
- Oracle Library cache mutex x tipsOracleMutex
- Oracle中flush buffer cache和x$bhOracle
- X明X源面試題《三》面試題
- 面試官:x !== x 可以為 true ?面試
- junit4.x and 3.x
- x$le及x$bh詳解
- 編譯原理: FIRST(x) FOLLOW(x) SELECT(x)的計算編譯原理
- vivo X7和X5/X5max/X5pro區別在哪?
- Oracle 19c - 手動升級 Oracle 12.x, 18c CDB 到 Oracle 19c (19.x)Oracle
- Oracle Exadata X2-8 介紹Oracle
- 配置 HugePages for Oracle on Linux (x86-64)OracleLinux
- Oracle 10g 中 X$KCVFH 說明Oracle 10g
- 壓力之下的Oracle10.1.0.XOracle
- Oracle釋出Solaris 11 for Sparc/x86Oracle
- Struts1.x Spring2.x Hibernate3.x DWR2.x 整合工具文件Spring
- OracleLinux-R7-U1-Server-x86_64下安裝oracle-11.2.0.4.0_linux_x86和x86_64OracleLinuxServer
- CSS-背景位置-x|background-position-xCSS
- vue-view-lazy:基於vue2.x懶載入解決方案VueView
- Requirements For Installing Oracle10gR2 on RHEL 5 x86 /x64UIREMOracle
- IOS基礎-設計UI@1X@2X@3X是什麼iOSUI
- 蘋果iPhone X和vivo X23區別對比評測 vivo X23和iPhone X哪個好?蘋果iPhone
- Window X86和X64的區別 Window x64和Window x86是什麼意思
- SharePlex for Oracle and Kafka 8.6.x 升級 9.2.3OracleKafka