| Lock held by a session not found in v$session [message #231700] |
Wed, 18 April 2007 03:40  |
chewcm
Messages: 3
Registered: April 2007
|
Junior Member |
|
|
See below a query I ran on v$locked_object:
SQL> select xidusn, xidslot, xidsqn, object_id, session_id, process, locked_mode
2 from v$locked_object where object_id = 27351;
XIDUSN XIDSLOT XIDSQN OBJECT_ID SESSION_ID PROCESS LOCKED_MODE
---------- ---------- ---------- ---------- ---------- ------------ -----------
0 0 0 27351 91 1234 3
32 4 174461 27351 131 3
0 0 0 27351 22 1234 3
The session (sid 131) is locking the table (object id 27351) and blocking sessions 22 and 91. However, I cannot find sid 131 in v$session. I also get no result if I query for sid 131 in v$lock. There's a corresponding record in v$transaction with status='PREPARED'. How do I get rid of the lock or kill the session?
|
|
|
|
|
|
|
|
| Re: Lock held by a session not found in v$session [message #231736 is a reply to message #231708] |
Wed, 18 April 2007 05:08  |
chewcm
Messages: 3
Registered: April 2007
|
Junior Member |
|
|
| Michel Cadot wrote on Wed, 18 April 2007 17:04 | This is a distributed transaction and maybe your db is not the coordinator.
You have to wait for the coordinator to end the distributed commit or use dbms_transaction to force the commit or the rollback.
|
I wanted to force commit or rollback the transaction. But it is not found in DBA_2PC_PENDING. So I'm not able to use COMMIT FORCE or ROLLBACK FORCE. Any other suggestions?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
