Database Administration (MOSC)

MOSC Banner

Is there a way to reverse engineer transaction based on one IUD clause in transaction?

edited Sep 24, 2014 5:01AM in Database Administration (MOSC) 2 commentsAnswered

Hello,

Is there a way to find all IUD clauses in one transaction* based on the identitiy of one IUD SQL clause which is located in V$% dictionary views?

For example:

1. Transaction is consisted from

1.1

Insert Into T1

Update  T2

Delete from T3

1.2 In V$ dictionary view we locate Update T2 set , ..where ...with host variables and constants

And on basis of this internal identification I would find

other two SQLs ( Insert, Delete ) on presumptions there is somewhere in the system recorded that

those 3 clauses happened in one commit operation.

2. Other example:

2.1 Insert Into T1...

     Loop

      Update T2

      exit when...

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center