How to Capture current running session transactions
yakub21Sep 12 2008 — edited Sep 13 2008Hi
Does anyone know how to capture a current running session processing base on a sid serial#?
I have a production java program that executes PL/SQL code and I can only see the current running session sql text, and I need to know what about uncommitted transactions such as inserting records into some error tables but the transactions are not committed until the end of the job. I'd like to know if it is possible to get a dump of the specific sid and serial# that is active . Thanks