【RAC】通過(guò)示例解釋PCM資源訪問(wèn)過(guò)程

1. 查看數(shù)據(jù)儲(chǔ)存的位置(FILE#,BLOCK#)

SELECT DBMS_ROWID.rowid_relative_fno (ROWID) "FILE#",
       DBMS_ROWID.rowid_block_number (ROWID) "BLOCK#",
       id,
       name
  FROM test.t2;

結(jié)果：

     FILE#     BLOCK#         ID NAME
---------- ---------- ---------- --------------------
     4    183          1 hello
     4    183          2 world

表T2的對(duì)象ID。

SELECT object_id, data_object_id
  FROM dba_objects
 WHERE owner = 'TEST' AND object_name = 'T2';

結(jié)果：

 OBJECT_ID DATA_OBJECT_ID
---------- --------------
     76431      76431

2. 查看對(duì)應(yīng)PCM鎖信息

1）@instance1-session1, 查看當(dāng)前會(huì)話的sid和spid, 以及查詢(xún)一條記錄

SQL> SELECT s.sid, p.spid
  FROM v$process p, v$session s
 WHERE p.addr = s.paddr AND s.sid = (SELECT DISTINCT sid FROM v$mystat);

       SID SPID
---------- ------------------------
       156 15837


SQL> SELECT *
  FROM test.t2
 WHERE id = 1;

    ID     NAME
---------- ------------------------------
     1     hello

3. 在新會(huì)話查看鎖和資源信息

@instance1-session2，查看會(huì)話的鎖和資源信息。

SQL> SELECT kjbrresp,
       kjbrgrant,
       kjbrncvl,
       kjbrrole,
       kjbrname,
       kjbrmaster,
       kjbrgrantq,
       kjbrcvtq,
       kjbrwriter,
       kjbrsid,
       kjbrpkey
  FROM x$kjbr
 WHERE kjbrname LIKE '%b7%4%BL%' AND kjbrpkey = 76  2    3    4    5    6    7    8    9   10   11   12   13  431;

no rows selected

@instance2-session2，查看會(huì)話的鎖和資源信息。

SQL> SELECT kjbrresp,
       kjbrgrant,
       kjbrncvl,
       kjbrrole,
       kjbrname,
       kjbrmaster,
       kjbrgrantq,
       kjbrcvtq,
       kjbrwriter,
       kjbrsid,
       kjbrpkey
  FROM x$kjbr
 WHERE kjbrname LIKE '%b7%4%BL%' AND kjbrpkey = 76431;

KJBRRESP     KJBRGRANT KJBRNCVL    KJBRROLE KJBRNAME
---------------- --------- --------- ---------- ------------------------------
KJBRMASTER KJBRGRANTQ       KJBRCVTQ         KJBRWRITER      KJBRSID
---------- ---------------- ---------------- ---------------- ----------
  KJBRPKEY
----------
000000009E4C0FE0 KJUSERPR  KJUSERNL       0 [0xb7][0x4],[BL][ext 0x0,0x0]
     1 000000009ED98A68 00           00                0
     76431

KJBRMASTER=1，說(shuō)明這個(gè)數(shù)據(jù)快的master是實(shí)例2所在的節(jié)點(diǎn)上。這時(shí)在實(shí)例1節(jié)點(diǎn)上執(zhí)行該語(yǔ)句是查不到記錄的。

SQL> SELECT kjblname,
       inst_id,
       kjbllockp,
       kjblgrant,
       kjblrequest,
       kjblrole,
       kjblmaster
  FROM x$kjbl
 WHERE kjblname LIKE '%b7%4%BL%' AND kjblpkey = 76431;

KJBLNAME              INST_ID KJBLLOCKP    KJBLGRANT KJBLREQUE   KJBLROLE KJBLMASTER
------------------------------ ---------- ---------------- --------- --------- ---------- ----------
[0xb7][0x4],[BL][ext 0x0,0x0]       2 000000009ED98A68 KJUSERPR  KJUSERNL       0      1

@instance1-session2，由于在實(shí)例1上進(jìn)行的記錄查詢(xún)操作，所以在該實(shí)例上查詢(xún)被訪問(wèn)的數(shù)據(jù)塊處于shared current模式（status=scur）。

SELECT b.file#,
       b.block#,
       b.status,
       b.lock_element_name,
       b.forced_reads,
       b.forced_writes,
       g.mode_held,
       g.block_count,
       g.local,
       g.flags
  FROM v$bh b, v$gc_element g
 WHERE b.lock_element_addr = g.gc_element_addr
   AND b.file# = 4
   AND b.block# = 183;

     FILE#     BLOCK# STATUS     LOCK_ELEMENT_NAME FORCED_READS FORCED_WRITES  MODE_HELD BLOCK_COUNT      LOCAL      FLAGS
---------- ---------- ---------- ----------------- ------------ ------------- ---------- ----------- ---------- ----------
     4    183 scur             183        0         0          1       1          1     32

4. 在實(shí)例2創(chuàng)建一個(gè)會(huì)話，查詢(xún)另一條記錄

@instance2-session1。（兩行記錄保存在同一個(gè)文件的同一個(gè)數(shù)據(jù)塊中）

SQL> SELECT s.sid, p.spid
  FROM v$process p, v$session s
 WHERE p.addr = s.paddr AND s.sid = (SELECT DISTINCT sid FROM v$mystat);

       SID SPID
---------- ------------------------
    38 31796

SELECT *
  FROM test.t2
 WHERE id = 2;

    ID NAME
---------- --------------------
     2 world

5. 查看PCM鎖及資源信息

@instance2-session2

SQL> SELECT b.file#,
       b.block#,
       b.status,
       b.lock_element_name,
       b.forced_reads,
       b.forced_writes,
       g.mode_held,
       g.block_count,
       g.local,
       g.flags
  FROM v$bh b, v$gc_element g
 WHERE b.lock_element_addr = g.gc_element_addr
       AND b.file# = 4
       AND b.block# = 183;

     FILE#     BLOCK# STATUS     LOCK_ELEMENT_NAME FORCED_READS FORCED_WRITES  MODE_HELD BLOCK_COUNT      LOCAL      FLAGS
---------- ---------- ---------- ----------------- ------------ ------------- ---------- ----------- ---------- ----------
     4    183 scur             183        0         0          1       1          1     32

SQL> SELECT kjbrresp,
       kjbrgrant,
       kjbrncvl,
       kjbrrole,
       kjbrname,
       kjbrmaster,
       kjbrgrantq,
       kjbrcvtq,
       kjbrwriter,
       kjbrsid,
       kjbrpkey
  FROM x$kjbr
 WHERE kjbrname LIKE '%b7%4%BL%' AND kjbrpkey = 76431;

KJBRRESP     KJBRGRANT KJBRNCVL    KJBRROLE KJBRNAME               KJBRMASTER KJBRGRANTQ       KJBRCVTQ     KJBRWRITER      KJBRSID   KJBRPKEY
---------------- --------- --------- ---------- ------------------------------ ---------- ---------------- ---------------- ---------------- ---------- ----------
000000009E4C0FE0 KJUSERPR  KJUSERNL       0 [0xb7][0x4],[BL][ext 0x0,0x0]       1 000000009ED98A68 00           00                0      76431

SELECT kjblname,
       inst_id,
       kjbllockp,
       kjblgrant,
       kjblrequest,
       kjblrole,
       kjblmaster
  FROM x$kjbl
 WHERE kjblname LIKE '%b7%4%BL%' AND kjblpkey = 76431;

KJBLNAME              INST_ID KJBLLOCKP    KJBLGRANT KJBLREQUE   KJBLROLE KJBLMASTER
------------------------------ ---------- ---------------- --------- --------- ---------- ----------
[0xb7][0x4],[BL][ext 0x0,0x0]       2 0000000069FC0A88 KJUSERPR  KJUSERNL       0      1
[0xb7][0x4],[BL][ext 0x0,0x0]       2 000000009ED98A68 KJUSERPR  KJUSERNL       0      1

@instance1-session2

SQL> SELECT kjblname,
       inst_id,
       kjbllockp,
       kjblgrant,
       kjblrequest,
       kjblrole,
       kjblmaster
  FROM x$kjbl
 WHERE kjblname LIKE '%b7%4%BL%' AND kjblpkey = 76431;
 
KJBLNAME              INST_ID KJBLLOCKP    KJBLGRANT KJBLREQUE   KJBLROLE KJBLMASTER
------------------------------ ---------- ---------------- --------- --------- ---------- ----------
[0xb7][0x4],[BL][ext 0x0,0x0]       1 0000000064FC5E78 KJUSERPR  KJUSERNL       0      1

6. 修改第一條記錄

@instance1-session1

update test.t2 set name='helloworld' where id=1;

1 row updated.

@instance1-session2

SQL> SELECT b.file#,
       b.block#,
       b.status,
       b.lock_element_name,
       b.forced_reads,
       b.forced_writes,
       g.mode_held,
       g.block_count,
       g.local,
       g.flags
  FROM v$bh b, v$gc_element g
 WHERE b.lock_element_addr = g.gc_element_addr
       AND b.file# = 4
       AND b.block# = 183;  

     FILE#     BLOCK# STATUS     LOCK_ELEMENT_NAME FORCED_READS FORCED_WRITES  MODE_HELD BLOCK_COUNT      LOCAL      FLAGS
---------- ---------- ---------- ----------------- ------------ ------------- ---------- ----------- ---------- ----------
     4    183 xcur             183        0         0          2       1          1     32

SQL> SELECT b.file#,
       b.block#,
       b.status,
       b.lock_element_name,
       b.forced_reads,
       b.forced_writes
  FROM v$bh b
 WHERE b.file# = 4 AND b.block# = 183;

     FILE#     BLOCK# STATUS     LOCK_ELEMENT_NAME FORCED_READS FORCED_WRITES
---------- ---------- ---------- ----------------- ------------ -------------
     4    183 xcur             183        0         0
     4    183 cr                      0         0

@instance2-session2

SQL> SELECT b.file#,
       b.block#,
       b.status,
       b.lock_element_name,
       b.forced_reads,
       b.forced_writes
  FROM v$bh b
 WHERE b.file# = 4 AND b.block# = 183; 

     FILE#     BLOCK# STATUS     LOCK_ELEMENT_NAME FORCED_READS FORCED_WRITES
---------- ---------- ---------- ----------------- ------------ -------------
     4    183 cr                      0         0

@instance2-session2（master）

SQL> SELECT kjbrresp,
       kjbrgrant,
       kjbrncvl,
       kjbrrole,
       kjbrname,
       kjbrmaster,
       kjbrgrantq,
       kjbrcvtq,
       kjbrwriter,
       kjbrsid,
       kjbrpkey
  FROM x$kjbr
 WHERE kjbrname LIKE '%b7%4%BL%' AND kjbrpkey = 76431;

KJBRRESP     KJBRGRANT KJBRNCVL    KJBRROLE KJBRNAME               KJBRMASTER KJBRGRANTQ       KJBRCVTQ     KJBRWRITER      KJBRSID   KJBRPKEY
---------------- --------- --------- ---------- ------------------------------ ---------- ---------------- ---------------- ---------------- ---------- ----------
000000009E4C0FE0 KJUSEREX  KJUSERNL       0 [0xb7][0x4],[BL][ext 0x0,0x0]       1 000000009ED98A68 00           00                0      76431

SQL> SELECT kjblname,
       inst_id,
       kjbllockp,
       kjblgrant,
       kjblrequest,
       kjblrole,
       kjblmaster
  FROM x$kjbl
 WHERE kjblname LIKE '%b7%4%BL%' AND kjblpkey = 76431; 

KJBLNAME              INST_ID KJBLLOCKP    KJBLGRANT KJBLREQUE   KJBLROLE KJBLMASTER
------------------------------ ---------- ---------------- --------- --------- ---------- ----------
[0xb7][0x4],[BL][ext 0x0,0x0]       2 000000009ED98A68 KJUSEREX  KJUSERNL       0      1

@instance1-session2

SQL> SELECT kjbrresp,
       kjbrgrant,
       kjbrncvl,
       kjbrrole,
       kjbrname,
       kjbrmaster,
       kjbrgrantq,
       kjbrcvtq,
       kjbrwriter,
       kjbrsid,
       kjbrpkey
  FROM x$kjbr
 WHERE kjbrname LIKE '%b7%4%BL%' AND kjbrpkey = 76431;  

no rows selected

SQL> SELECT kjblname,
       inst_id,
       kjbllockp,
       kjblgrant,
       kjblrequest,
       kjblrole,
       kjblmaster
  FROM x$kjbl
 WHERE kjblname LIKE '%b7%4%BL%' AND kjblpkey = 76431;  

KJBLNAME              INST_ID KJBLLOCKP    KJBLGRANT KJBLREQUE   KJBLROLE KJBLMASTER
------------------------------ ---------- ---------------- --------- --------- ---------- ----------
[0xb7][0x4],[BL][ext 0x0,0x0]       1 0000000064FC5E78 KJUSEREX  KJUSERNL       0      1

7. 更新第二條記錄

@instance2-session1

SQL> update test.t2 set name='worldhello' where id=2;

1 row updated.

@instance2-session2

SQL> SELECT b.file#,
       b.block#,
       b.status,
       b.lock_element_name,
       b.forced_reads,
       b.forced_writes,
       g.mode_held,
       g.block_count,
       g.local,
       g.flags
  FROM v$bh b, v$gc_element g
 WHERE b.lock_element_addr =  g.gc_element_addr
       AND b.file# = 4
       AND b.block# = 183;

     FILE#     BLOCK# STATUS     LOCK_ELEMENT_NAME FORCED_READS FORCED_WRITES  MODE_HELD BLOCK_COUNT      LOCAL      FLAGS
---------- ---------- ---------- ----------------- ------------ ------------- ---------- ----------- ---------- ----------
     4    183 xcur             183        0         0          2       1          0     32

@instance1-sesssion2

SQL> SELECT b.file#,
       b.block#,
       b.status,
       b.lock_element_name,
       b.forced_reads,
       b.forced_writes
  FROM v$bh b
 WHERE b.file# = 4 AND b.block# = 183; 

     FILE#     BLOCK# STATUS     LOCK_ELEMENT_NAME FORCED_READS FORCED_WRITES
---------- ---------- ---------- ----------------- ------------ -------------
     4    183 pi               183        0         0
     4    183 cr                      0         0
     4    183 cr                      0         0
     4    183 cr                      0         0

@instance2-session2

SQL> SELECT b.file#,
       b.block#,
       b.status,
       b.lock_element_name,
       b.forced_reads,
       b.forced_writes
  FROM v$bh b
 WHERE b.file# = 4 AND b.block# = 183;

     FILE#     BLOCK# STATUS     LOCK_ELEMENT_NAME FORCED_READS FORCED_WRITES
---------- ---------- ---------- ----------------- ------------ -------------
     4    183 xcur             183        0         0
     4    183 cr                      0         0
     4    183 cr                      0         0
     4    183 cr                      0         0

@instance1-session2

SQL> SELECT kjbrresp,
       kjbrgrant,
       kjbrncvl,
       kjbrrole,
       kjbrname,
       kjbrmaster,
       kjbrgrantq,
       kjbrcvtq,
       kjbrwriter,
       kjbrsid,
       kjbrpkey
  FROM x$kjbr
 WHERE kjbrname LIKE '%b7%4%BL%' AND kjbrpkey = 76431;

no rows selected

SQL> SELECT kjblname,
       inst_id,
       kjbllockp,
       kjblgrant,
       kjblrequest,
       kjblrole,
       kjblmaster
  FROM x$kjbl
 WHERE kjblname LIKE '%b7%4%BL%' AND kjblpkey = 76431;  

KJBLNAME              INST_ID KJBLLOCKP    KJBLGRANT KJBLREQUE   KJBLROLE KJBLMASTER
------------------------------ ---------- ---------------- --------- --------- ---------- ----------
[0xb7][0x4],[BL][ext 0x0,0x0]       1 0000000064FC5E78 KJUSERNL  KJUSERNL         192      1

@instance2-session2

SQL> SELECT kjbrresp,
       kjbrgrant,
       kjbrncvl,
       kjbrrole,
       kjbrname,
       kjbrmaster,
       kjbrgrantq,
       kjbrcvtq,
       kjbrwriter,
       kjbrsid,
       kjbrpkey
  FROM x$kjbr
 WHERE kjbrname LIKE '%b7%4%BL%' AND kjbrpkey = 76431;

KJBRRESP     KJBRGRANT KJBRNCVL    KJBRROLE KJBRNAME               KJBRMASTER KJBRGRANTQ       KJBRCVTQ     KJBRWRITER      KJBRSID   KJBRPKEY
---------------- --------- --------- ---------- ------------------------------ ---------- ---------------- ---------------- ---------------- ---------- ----------
000000009E4C0FE0 KJUSEREX  KJUSERNL      64 [0xb7][0x4],[BL][ext 0x0,0x0]       1 000000009ED98A68 00           00                0      76431

SQL> SELECT kjblname,
       inst_id,
       kjbllockp,
       kjblgrant,
       kjblrequest,
       kjblrole,
       kjblmaster
  FROM x$kjbl
 WHERE kjblname LIKE '%b7%4%BL%' AND kjblpkey = 76431;  

KJBLNAME              INST_ID KJBLLOCKP    KJBLGRANT KJBLREQUE   KJBLROLE KJBLMASTER
------------------------------ ---------- ---------------- --------- --------- ---------- ----------
[0xb7][0x4],[BL][ext 0x0,0x0]       2 0000000069FC0A88 KJUSEREX  KJUSERNL          64      1
[0xb7][0x4],[BL][ext 0x0,0x0]       2 000000009ED98A68 KJUSERNL  KJUSERNL         192      1

8. 更新提交

@instance2-session1

SQL> commit;

Commit complete.

@instance1-session1

SQL> commit;

Commit complete.

@instance1-session2

SQL> select * from test.t2;

    ID NAME
---------- --------------------
     1 helloworld
     2 worldhello

SQL> SELECT b.file#,
       b.block#,
       b.status,
       b.lock_element_name,
       b.forced_reads,
       b.forced_writes
  FROM v$bh b
 WHERE b.file# = 4 AND b.block# = 183;

     FILE#     BLOCK# STATUS     LOCK_ELEMENT_NAME FORCED_READS FORCED_WRITES
---------- ---------- ---------- ----------------- ------------ -------------
     4    183 pi               183        0         0
     4    183 xcur             183        0         0
     4    183 cr                      0         0
     4    183 cr                      0         0
     4    183 cr                      0         0

@instance2-session2

SQL> SELECT b.file#,
       b.block#,
       b.status,
       b.lock_element_name,
       b.forced_reads,
       b.forced_writes
  FROM v$bh b
 WHERE b.file# = 4 AND b.block# = 183;

     FILE#     BLOCK# STATUS     LOCK_ELEMENT_NAME FORCED_READS FORCED_WRITES
---------- ---------- ---------- ----------------- ------------ -------------
     4    183 cr                      0         0
     4    183 cr                      0         0
     4    183 cr                      0         0
     4    183 cr                      0         0

@instance1-session2

SQL> SELECT kjbrresp,
       kjbrgrant,
       kjbrncvl,
       kjbrrole,
       kjbrname,
       kjbrmaster,
       kjbrgrantq,
       kjbrcvtq,
       kjbrwriter,
       kjbrsid,
       kjbrpkey
  FROM x$kjbr
 WHERE kjbrname LIKE '%b7%4%BL%' AND kjbrpkey = 76431;

no rows selected

SQL> SELECT kjblname,
       inst_id,
       kjbllockp,
       kjblgrant,
       kjblrequest,
       kjblrole,
       kjblmaster
  FROM x$kjbl
 WHERE kjblname LIKE '%b7%4%BL%' AND kjblpkey = 76431;  

KJBLNAME              INST_ID KJBLLOCKP    KJBLGRANT KJBLREQUE   KJBLROLE KJBLMASTER
------------------------------ ---------- ---------------- --------- --------- ---------- ----------
[0xb7][0x4],[BL][ext 0x0,0x0]       1 0000000064FC5E78 KJUSEREX  KJUSERNL       0      1

@instance2-session2

SQL> SELECT kjbrresp,
       kjbrgrant,
       kjbrncvl,
       kjbrrole,
       kjbrname,
       kjbrmaster,
       kjbrgrantq,
       kjbrcvtq,
       kjbrwriter,
       kjbrsid,
       kjbrpkey
  FROM x$kjbr
 WHERE kjbrname LIKE '%b7%4%BL%' AND kjbrpkey = 76431; 

KJBRRESP     KJBRGRANT KJBRNCVL    KJBRROLE KJBRNAME               KJBRMASTER KJBRGRANTQ       KJBRCVTQ     KJBRWRITER      KJBRSID   KJBRPKEY
---------------- --------- --------- ---------- ------------------------------ ---------- ---------------- ---------------- ---------------- ---------- ----------
000000009E4C0FE0 KJUSEREX  KJUSERNL       0 [0xb7][0x4],[BL][ext 0x0,0x0]       1 000000009ED98A68 00           00                0      76431

SQL> SELECT kjblname,
       inst_id,
       kjbllockp,
       kjblgrant,
       kjblrequest,
       kjblrole,
       kjblmaster
  FROM x$kjbl
 WHERE kjblname LIKE '%b7%4%BL%' AND kjblpkey = 76431;  

KJBLNAME              INST_ID KJBLLOCKP    KJBLGRANT KJBLREQUE   KJBLROLE KJBLMASTER
------------------------------ ---------- ---------------- --------- --------- ---------- ----------
[0xb7][0x4],[BL][ext 0x0,0x0]       2 000000009ED98A68 KJUSEREX  KJUSERNL       0      1

9. 在實(shí)例2發(fā)起檢查點(diǎn)操作

@instance2-session1

SQL> alter system checkpoint;

System altered.

@instance1-session2

SQL> SELECT b.file#,
       b.block#,
       b.status,
       b.lock_element_name,
       b.forced_reads,
       b.forced_writes
  FROM v$bh b
 WHERE b.file# = 4 AND b.block# = 183; 

     FILE#     BLOCK# STATUS     LOCK_ELEMENT_NAME FORCED_READS FORCED_WRITES
---------- ---------- ---------- ----------------- ------------ -------------
     4    183 xcur             183        0         0
     4    183 cr                      0         0
     4    183 cr                      0         0
     4    183 cr                      0         0
     4    183 cr                      0         0

@instance2-session2

SQL> SELECT b.file#,
       b.block#,
       b.status,
       b.lock_element_name,
       b.forced_reads,
       b.forced_writes
  FROM v$bh b
 WHERE b.file# = 4 AND b.block# = 183; 

     FILE#     BLOCK# STATUS     LOCK_ELEMENT_NAME FORCED_READS FORCED_WRITES
---------- ---------- ---------- ----------------- ------------ -------------
     4    183 cr                      0         0
     4    183 cr                      0         0
     4    183 cr                      0         0
     4    183 cr                      0         0

@instance1-session2

SQL> SELECT kjbrresp,
       kjbrgrant,
       kjbrncvl,
       kjbrrole,
       kjbrname,
       kjbrmaster,
       kjbrgrantq,
       kjbrcvtq,
       kjbrwriter,
       kjbrsid,
       kjbrpkey
  FROM x$kjbr
 WHERE kjbrname LIKE '%b7%4%BL%' AND kjbrpkey = 76431;  

no rows selected

SQL> SELECT kjblname,
       inst_id,
       kjbllockp,
       kjblgrant,
       kjblrequest,
       kjblrole,
       kjblmaster
  FROM x$kjbl
 WHERE kjblname LIKE '%b7%4%BL%' AND kjblpkey = 76431; 

KJBLNAME              INST_ID KJBLLOCKP    KJBLGRANT KJBLREQUE   KJBLROLE KJBLMASTER
------------------------------ ---------- ---------------- --------- --------- ---------- ----------
[0xb7][0x4],[BL][ext 0x0,0x0]       1 0000000064FC5E78 KJUSEREX  KJUSERNL       0      1

@instance2-session2

SQL> SELECT kjbrresp,
       kjbrgrant,
       kjbrncvl,
       kjbrrole,
       kjbrname,
       kjbrmaster,
       kjbrgrantq,
       kjbrcvtq,
       kjbrwriter,
       kjbrsid,
       kjbrpkey
  FROM x$kjbr
 WHERE kjbrname LIKE '%b7%4%BL%' AND kjbrpkey = 76431; 

KJBRRESP     KJBRGRANT KJBRNCVL    KJBRROLE KJBRNAME               KJBRMASTER KJBRGRANTQ       KJBRCVTQ     KJBRWRITER      KJBRSID   KJBRPKEY
---------------- --------- --------- ---------- ------------------------------ ---------- ---------------- ---------------- ---------------- ---------- ----------
000000009E4C0FE0 KJUSEREX  KJUSERNL       0 [0xb7][0x4],[BL][ext 0x0,0x0]       1 000000009ED98A68 00           00                0      76431

SQL> SELECT kjblname,
       inst_id,
       kjbllockp,
       kjblgrant,
       kjblrequest,
       kjblrole,
       kjblmaster
  FROM x$kjbl
 WHERE kjblname LIKE '%b7%4%BL%' AND kjblpkey = 76431;  

KJBLNAME              INST_ID KJBLLOCKP    KJBLGRANT KJBLREQUE   KJBLROLE KJBLMASTER
------------------------------ ---------- ---------------- --------- --------- ---------- ----------
[0xb7][0x4],[BL][ext 0x0,0x0]       2 000000009ED98A68 KJUSEREX  KJUSERNL       0      1
?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請(qǐng)聯(lián)系作者
【社區(qū)內(nèi)容提示】社區(qū)部分內(nèi)容疑似由AI輔助生成，瀏覽時(shí)請(qǐng)結(jié)合常識(shí)與多方信息審慎甄別。
平臺(tái)聲明：文章內(nèi)容（如有圖片或視頻亦包括在內(nèi)）由作者上傳并發(fā)布，文章內(nèi)容僅代表作者本人觀點(diǎn)，簡(jiǎn)書(shū)系信息發(fā)布平臺(tái)，僅提供信息存儲(chǔ)服務(wù)。

相關(guān)閱讀更多精彩內(nèi)容

  • 關(guān)于Mongodb的全面總結(jié) MongoDB的內(nèi)部構(gòu)造《MongoDB The Definitive Guide》...
    中v中閱讀 32,305評(píng)論 2贊 89
  • MySQL技術(shù)內(nèi)幕：InnoDB存儲(chǔ)引擎(第2版) 姜承堯 第1章 MySQL體系結(jié)構(gòu)和存儲(chǔ)引擎 >> 在上述例子...
    沉默劍士閱讀 7,642評(píng)論 0贊 16
  • ORA-00001: 違反唯一約束條件 (.) 錯(cuò)誤說(shuō)明：當(dāng)在唯一索引所對(duì)應(yīng)的列上鍵入重復(fù)值時(shí)，會(huì)觸發(fā)此異常。 O...
    我想起個(gè)好名字閱讀 5,971評(píng)論 0贊 9
  • 2017年7月11日 1.感恩爸媽的養(yǎng)育之恩幫忙照顧孩子。 2.感恩兒子磨練我。 3.感恩先生為家努力付出。 4....
    馮梓源閱讀 247評(píng)論 0贊 0
  • 當(dāng)今社會(huì)科技突飛猛進(jìn)，文化也與時(shí)俱進(jìn)，這讓我不得不徹底醒悟，人也必須跟上它的節(jié)拍，否則就會(huì)讓它給埋沒(méi)。但有些卻是歷...
    胡研閱讀 226評(píng)論 0贊 0

友情鏈接更多精彩內(nèi)容