【RAC】通過示例解釋PCM資源訪問過程

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, 以及查詢一條記錄

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听皿，說明這個(gè)數(shù)據(jù)快的master是實(shí)例2所在的節(jié)點(diǎn)上徐紧。這時(shí)在實(shí)例1節(jié)點(diǎn)上執(zhí)行該語句是查不到記錄的个绍。

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)行的記錄查詢操作，所以在該實(shí)例上查詢被訪問的數(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ì)話凛虽，查詢另一條記錄

@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)系作者
  • 人面猴
    序言：七十年代末广恢，一起剝皮案震驚了整個(gè)濱河市凯旋，隨后出現(xiàn)的幾起案子，更是在濱河造成了極大的恐慌钉迷，老刑警劉巖至非，帶你破解...
    沈念sama閱讀 219,490評(píng)論 6贊 508
  • 死咒
    序言：濱河連續(xù)發(fā)生了三起死亡事件，死亡現(xiàn)場離奇詭異糠聪，居然都是意外死亡荒椭，警方通過查閱死者的電腦和手機(jī)，發(fā)現(xiàn)死者居然都...
    沈念sama閱讀 93,581評(píng)論 3贊 395
  • 救了他兩次的神仙讓他今天三更去死
    文/潘曉璐 我一進(jìn)店門舰蟆，熙熙樓的掌柜王于貴愁眉苦臉地迎上來趣惠，“玉大人，你說我怎么就攤上這事身害∥肚模” “怎么了？”我有些...
    開封第一講書人閱讀 165,830評(píng)論 0贊 356
  • 道士緝兇錄：失蹤的賣姜人
    文/不壞的土叔 我叫張陵塌鸯，是天一觀的道長侍瑟。 經(jīng)常有香客問我，道長丙猬，這世上最難降的妖魔是什么涨颜？ 我笑而不...
    開封第一講書人閱讀 58,957評(píng)論 1贊 295
  • ?港島之戀（遺憾婚禮）
    正文 為了忘掉前任，我火速辦了婚禮茧球，結(jié)果婚禮上庭瑰，老公的妹妹穿的比我還像新娘。我一直安慰自己袜腥，他們只是感情好见擦，可當(dāng)我...
    茶點(diǎn)故事閱讀 67,974評(píng)論 6贊 393
  • 惡毒庶女頂嫁案：這布局不是一般人想出來的
    文/花漫 我一把揭開白布钉汗。 她就那樣靜靜地躺著羹令，像睡著了一般。 火紅的嫁衣襯著肌膚如雪损痰。 梳的紋絲不亂的頭發(fā)上福侈，一...
    開封第一講書人閱讀 51,754評(píng)論 1贊 307
  • 城市分裂傳說
    那天，我揣著相機(jī)與錄音卢未，去河邊找鬼肪凛。 笑死，一個(gè)胖子當(dāng)著我的面吹牛伟墙，可吹牛的內(nèi)容都是我干的翘鸭。 我是一名探鬼主播，決...
    沈念sama閱讀 40,464評(píng)論 3贊 420
  • 雙鴛鴦連環(huán)套：你想象不到人心有多黑
    文/蒼蘭香墨 我猛地睜開眼戳葵，長吁一口氣：“原來是場噩夢啊……” “哼就乓！你這毒婦竟也來了？” 一聲冷哼從身側(cè)響起拱烁，我...
    開封第一講書人閱讀 39,357評(píng)論 0贊 276
  • 萬榮殺人案實(shí)錄
    序言：老撾萬榮一對(duì)情侶失蹤生蚁，失蹤者是張志新（化名）和其女友劉穎，沒想到半個(gè)月后戏自，有當(dāng)?shù)厝嗽跇淞掷锇l(fā)現(xiàn)了一具尸體邦投，經(jīng)...
    沈念sama閱讀 45,847評(píng)論 1贊 317
  • ?護(hù)林員之死
    正文 獨(dú)居荒郊野嶺守林人離奇死亡，尸身上長有42處帶血的膿包…… 初始之章·張勛 以下內(nèi)容為張勛視角 年9月15日...
    茶點(diǎn)故事閱讀 37,995評(píng)論 3贊 338
  • ?白月光啟示錄
    正文 我和宋清朗相戀三年擅笔，在試婚紗的時(shí)候發(fā)現(xiàn)自己被綠了志衣。 大學(xué)時(shí)的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片。...
    茶點(diǎn)故事閱讀 40,137評(píng)論 1贊 351
  • 活死人
    序言：一個(gè)原本活蹦亂跳的男人離奇死亡剂娄，死狀恐怖蠢涝，靈堂內(nèi)的尸體忽然破棺而出，到底是詐尸還是另有隱情阅懦，我是刑警寧澤和二，帶...
    沈念sama閱讀 35,819評(píng)論 5贊 346
  • ?日本核電站爆炸內(nèi)幕
    正文 年R本政府宣布，位于F島的核電站耳胎，受9級(jí)特大地震影響惯吕，放射性物質(zhì)發(fā)生泄漏。R本人自食惡果不足惜怕午，卻給世界環(huán)境...
    茶點(diǎn)故事閱讀 41,482評(píng)論 3贊 331
  • 男人毒藥：我在死后第九天來索命
    文/蒙蒙 一废登、第九天 我趴在偏房一處隱蔽的房頂上張望。 院中可真熱鬧郁惜，春花似錦堡距、人聲如沸。這莊子的主人今日做“春日...
    開封第一講書人閱讀 32,023評(píng)論 0贊 22
  • 一樁弒父案羽戒，背后竟有這般陰謀
    文/蒼蘭香墨 我抬頭看了看天上的太陽。三九已至虎韵，卻和暖如春易稠，著一層夾襖步出監(jiān)牢的瞬間，已是汗流浹背包蓝。 一陣腳步聲響...
    開封第一講書人閱讀 33,149評(píng)論 1贊 272
  • 情欲美人皮
    我被黑心中介騙來泰國打工驶社， 沒想到剛下飛機(jī)就差點(diǎn)兒被人妖公主榨干…… 1. 我叫王不留企量，地道東北人。 一個(gè)月前我還...
    沈念sama閱讀 48,409評(píng)論 3贊 373
  • 代替公主和親
    正文 我出身青樓亡电，卻偏偏與公主長得像届巩，于是被迫代替她去往敵國和親。 傳聞我的和親對(duì)象是個(gè)殘疾皇子份乒，可洞房花燭夜當(dāng)晚...
    茶點(diǎn)故事閱讀 45,086評(píng)論 2贊 355

推薦閱讀更多精彩內(nèi)容

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