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 identify different transactions within one session

820951Apr 24 2011 — edited Apr 24 2011

Hi

I have one open connection and I am issuing 10 selects I need to know any identifier within that session that could tell me that the first select is completed and is now running the second one and so on. Is there any environment variable or any value any where that can tell me that for session XYZ I am executing AAA query and if I issue the second one it tells me for session XYZ I am executing BBB query.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 22 2011

Added on Apr 24 2011

#general-database-discussions

8 comments

241 views