NAME
MODE_HELD
---------- ------------------------------------------------------------ ------------------------------------------------------------ --------------------------
373 SCOTT
T_DRIVEWAYDATA
Row-X (SX)
245 SCOTT
T_DRIVEWAYDATA
Row-X (SX)
373 SYS
SEQ$
Row-X (SX)
124 SYS
PLAN_TABLE$
Row-X (SX)
126 SCOTT
T_DRIVEWAYDATA
Row-X (SX)
363 SCOTT
T_DRIVEWAYDATA
Row-X (SX)
已选择
6
行。
2
、依据上文找到
sid
,查询锁住的
sql
语句
SQL> select b.sql_text from v$session a,v$sqlarea b where a.sql_hash_value=b.hash_value and a.sid='126';
SQL_TEXT
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------