Home » SQL & PL/SQL » SQL & PL/SQL » How to Retrieve transaction time in MilliSeconds
How to Retrieve transaction time in MilliSeconds [message #251590] Sun, 15 July 2007 04:20 Go to next message
ahmedms101
Messages: 4
Registered: July 2007
Location: Cairo
Junior Member
i am making a transaction against the database and i want to get the time when this transaction begin and end with milliseconds so i can get the difference indicate how much is the time to make that transaction in milliseconds

how can i accomplish that?
Re: How to Retrieve transaction time in MilliSeconds [message #251594 is a reply to message #251590] Sun, 15 July 2007 05:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
  1. Log Miner
  2. FLASHBACK_TRANSACTION_QUERY
  3. Application using SYSTIMESTAMP at the beginning and end of its transaction

Regards
Michel
Re: How to Retrieve transaction time in MilliSeconds [message #251597 is a reply to message #251590] Sun, 15 July 2007 06:13 Go to previous message
ahmedms101
Messages: 4
Registered: July 2007
Location: Cairo
Junior Member
thanx for the help
Previous Topic: NULL values & UNIQUE Key
Next Topic: how to pass a current transaction values in statement level triggers?
Goto Forum:
  


Current Time: Sat Dec 10 20:18:06 CST 2016

Total time taken to generate the page: 0.11775 seconds