Home » SQL & PL/SQL » SQL & PL/SQL » Tracing Updates (oracle 10g)
Tracing Updates [message #411116] Thu, 02 July 2009 01:10 Go to next message
ravi214u
Messages: 153
Registered: February 2008
Location: CANADA
Senior Member
Hi,

I have a process tree which consists of nearly 50 tasks(all are updates based on different conditions).And all the 50 task are updating the same column or override the same based on different conditions.

So my requirement is to trace the update which is updating or override row by row( e g 5th update statement update the 20th row in a table. so i will be able to record that update) .Is it possible to capture this requirement.

any idea or hint will be very usefull.
Re: Tracing Updates [message #411118 is a reply to message #411116] Thu, 02 July 2009 01:30 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Flashback transaction query might help. Please read-up on it so we can discuss it further.
Re: Tracing Updates [message #411127 is a reply to message #411116] Thu, 02 July 2009 01:54 Go to previous messageGo to next message
ravi214u
Messages: 153
Registered: February 2008
Location: CANADA
Senior Member
Thanks Frank, I read some thing about flashback transaction query.
As per my understanding it will give the row by row information about update and the update statement as well.Now the question is how do we recongnise which update statement has updated this row.
Is XID fixed for a particular update or it will change randomly.
any suggestions.
Re: Tracing Updates [message #411134 is a reply to message #411127] Thu, 02 July 2009 02:25 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
XID (transaction id) is fixed for a transaction and so for a statement but is the same for several statements in the same transaction.

Regards
Michel
Previous Topic: Creating oracle table from external files
Next Topic: Partition error
Goto Forum:
  


Current Time: Sat Dec 03 20:35:30 CST 2016

Total time taken to generate the page: 0.12413 seconds