Skip to Main Content

SQL & PL/SQL

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 Check which Statements are executed for a Session

user8400219Jul 14 2017 — edited Jul 24 2017

Hi Team,

Is there any possible way to identify which DML statements are executed for a specific session and also there respective undo statements. Somebody suggested me LOGMINER to be used but can we identify SQL specific to session in it.

Is there any other way except Logminer.

What i am trying is, suppose an application made a session on database and after that some Statements are executed on the database for that session on schema, In that case i want to find out all the statements executed along with there sequence and there respective undo statements only for that session.

Thanks in advance for the help.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 21 2017
Added on Jul 14 2017
11 comments
602 views