Home » SQL & PL/SQL » SQL & PL/SQL » how can i identified very recent DML transaction (oracle 9i)
how can i identified very recent DML transaction [message #317829] Sun, 04 May 2008 00:37 Go to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi,

I Want to know the Very Recent DML Transaction.

pls guide me.

Thanks.

Wbr

kanish
Re: how can i identified very recent DML transaction [message #317831 is a reply to message #317829] Sun, 04 May 2008 01:45 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The only way in 9i, if you didn't set any audit, is to mine the logs (see LogMiner).

Regards
Michel
Previous Topic: Null Value during the Execution of Query
Next Topic: trigger for restricting insertion into table through the SQL*plus
Goto Forum:
  


Current Time: Tue Dec 06 16:01:33 CST 2016

Total time taken to generate the page: 0.05147 seconds