rollback another user's transaction

Thanks all for your feedback.

Hrishy - As of now, I am unaware about mining AWR table. I will read the docs and would use it next time if I fall into this situation.

i doubt its got to be some background process, check program column in v$session. Or it could also be a slave process that is spawned when u run a query in parallel mode. You have to kill the session to free the blocked object, also check v$lock, v$locked_object etc.

HTH

Hi

Take the sql_id you have and get teh value of the sql text from the table
DBA_HIST_SQLTEXT

DBA_HIST_SQLTEXT stores the sql_id and the sql_text as clob.

regards
Hrishy

Check this document.

http://www.filibeto.org/sun/lib/nons..._txnman007.htm

PS: I've personally never tried this.

I have tried solution in the link posted by malay_biswal, but it will only work on distributed transactions.
:cool:

Hrishy--- That's what, the sql_id is showing NULL for blocker session.

Why don't you post the v$session contents for that user, so that we know what this session is for?

gtcol-- Sorry! Actually yesterday, I killed that session at customer site in off production hours. I did it in off production hours because I wasn't sure of the cascading effects on the application.

But I checked the Program column, it was showing the name of application "QuarkDMS.exe". FYI, Everything is hosted on Windows 2003 Server.

Quote:

---

But I checked the Program column, it was showing the name of application "QuarkDMS.exe".

---

Seems like a user session. It could also be a slip-up in your application logic itself if you're sure that this will pile up again and killing it requires application restart. Next time, you can see in detail like program, osuser, sql_id, ROW_WAIT_OBJ#, CLIENT_IDENTIFIER, event, WAIT_CLASS etc in v$session. Also, see v$lock, v$ocked_object etc.

HTH