Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Capture current running session transactions

yakub21Sep 12 2008 — edited Sep 13 2008
Hi

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2008
Added on Sep 12 2008
6 comments
986 views