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 find osuser or machine name or ip address of a transaction?

761748Mar 21 2011 — edited Mar 21 2011

Hi, I want to find who has committed the transaction? The transaction commited time
is in Undo Retention time period. I have no audit.
I can query the transaction from flashback_transaction_query but this does not give osuser or machine name of the client who has commited.
Is there a way? Thank you?

This post has been answered by Aman.... on Mar 21 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 18 2011

Added on Mar 21 2011

#general-database-discussions

10 comments

1,549 views