Home » RDBMS Server » Server Administration » DML(s) related to transactions
DML(s) related to transactions [message #301232] Tue, 19 February 2008 14:20 Go to next message
kazdba
Messages: 10
Registered: February 2008
Junior Member
How can we identify the DML(s) related to active transaction?

For example I would like to see the insert/update/delete statement related to a transaction.
Re: DML(s) related to transactions [message #301233 is a reply to message #301232] Tue, 19 February 2008 14:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, the only way is to mine the logs (in 9.2 and below).

Regards
Michel
Re: DML(s) related to transactions [message #301237 is a reply to message #301233] Tue, 19 February 2008 14:46 Go to previous messageGo to next message
kazdba
Messages: 10
Registered: February 2008
Junior Member
Is it possible in 10g? if yes then can you provide the solution.

thx.
Re: DML(s) related to transactions [message #301238 is a reply to message #301237] Tue, 19 February 2008 14:53 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is named "Flashback transaction query".
You don't have the actual statements but you have all the modifications made.

Regards
Michel

[Updated on: Tue, 19 February 2008 14:54]

Report message to a moderator

Previous Topic: startup problem pla help me out
Next Topic: How to Recreate Password File
Goto Forum:
  


Current Time: Sat Dec 10 16:24:26 CST 2016

Total time taken to generate the page: 0.11482 seconds