我的是10G
SQL> SELECT addr, kglhdadr, kglhdpar, kglnaown, kglnaobj, kglnahsh, kglhdobj
2FROM x$kglob
3WHERE kglhdadr IN (SELECT p1raw
4
FROM v$session_wait
5
WHERE event LIKE '%library%')
6/
no rows selected
SQL> /
ADDR
KGLHDADR KGLHDPAR
---------------- ---------------- ----------------
KGLNAOWN
--------------------------------------------------------------------------------
KGLNAOBJ
--------------------------------------------------------------------------------
KGLNAHSH KGLHDOBJ
---------- ----------------
0000002A97233468 00000000B5D9E258 00000000B5D9E258
SYS
LIB_TEST
2173132718 00000000B4EF9BD0
SQL> /
ADDR
KGLHDADR KGLHDPAR
---------------- ---------------- ----------------
KGLNAOWN
--------------------------------------------------------------------------------
KGLNAOBJ
--------------------------------------------------------------------------------
KGLNAHSH KGLHDOBJ
---------- ----------------
0000002A97233468 00000000B5D9E258 00000000B5D9E258
SYS
LIB_TEST
2173132718 00000000B4EF9BD0
SQL> /
ADDR
KGLHDADR KGLHDPAR
---------------- ---------------- ----------------
KGLNAOWN
--------------------------------------------------------------------------------
KGLNAOBJ
--------------------------------------------------------------------------------
KGLNAHSH KGLHDOBJ
---------- ----------------
0000002A972333F0 00000000B5D9E258 00000000B5D9E258
SYS
LIB_TEST
2173132718 00000000B4EF9BD0
SQL> SELECT SID
2
FROM v$session a, x$kglpn b
3
WHERE a.saddr = b.kglpnuse
4
AND b.kglpnmod0
5
AND b.kglpnhdl IN (SELECT p1raw
6
FROM v$session_wait
7
WHERE event LIKE 'library%')
8/
no rows selected
SQL> /
SID
----------
147
SQL> /
SID
----------
147
SQL> /
no rows selected
SQL> /
no rows selected
SQL> /
no rows selected
SQL> /
SID
----------
147
SQL> /
SID
----------
147
SQL> /
SID
----------
147
SQL> /
SID
----------
145
SQL> select sql_hash_value,sql_address from v$session where sid=147;
SQL_HASH_VALUE SQL_ADDRESS
-------------- ----------------
0 0000002A9720F7B0
SQL>
SQL> /
SQL_HASH_VALUE SQL_ADDRESS
-------------- ----------------
0 0000002A9720F7B0
SQL> /
SQL_HASH_VALUE SQL_ADDRESS
-------------- ----------------
0 0000002A9720F7B0
SQL> /
SQL_HASH_VALUE SQL_ADDRESS
-------------- ----------------
0 0000002A9720F7B0
SQL> /
SQL_HASH_VALUE SQL_ADDRESS
-------------- ----------------
0 0000002A9720F7B0
SQL> /
SQL_HASH_VALUE SQL_ADDRESS
-------------- ----------------
0 0000002A9720F7B0
SQL> /
SQL_HASH_VALUE SQL_ADDRESS
-------------- ----------------
0 0000002A9720F7B0
SQL> /
SQL_HASH_VALUE SQL_ADDRESS
-------------- ----------------
0 0000002A9720F7B0
SQL> /
SQL_HASH_VALUE SQL_ADDRESS
-------------- ----------------
0 0000002A9720F7B0
SQL> /
SQL_HASH_VALUE SQL_ADDRESS
-------------- ----------------
0 0000002A9720F7B0
多执行还是可以查到的
但是SQL是查不到的可以看到HASH_VALUE是0
可能跟你那个存储过程有关系，如果是个alert 什么的是可以的
======================================
session 1
alter table data addtest3 number default 0;
session 2
update data set owner='1';
SQL> SELECT SID
2
FROM v$session a, x$kglpn b
3
WHERE a.saddr = b.kglpnuse
4
AND b.kglpnmod0
5
AND b.kglpnhdl IN (SELECT p1raw
6
FROM v$session_wait
7
WHERE event LIKE 'library%')
8/
SID
----------
145
SQL> select sql_hash_value ,sql_id from v$session where sid=145;
SQL_HASH_VALUE SQL_ID
-------------- ---------------------------------------
2981744651 d9y4ghysvmn0b
SQL> select sql_text from v$sql where sql_id='d9y4ghysvmn0b';
SQL_TEXT
--------------------------------------------------------------------------------
alter table data addtest3 number default 0 |
