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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No, the only way is to mine the logs (in 9.2 and below).

Regards
Michel

Report message to a moderator

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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 23:42:49 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.