Home » RDBMS Server » Server Administration » Insert duration (Oracle 10g , 10.2.0,Linux AS4)
Insert duration [message #312624] Wed, 09 April 2008 08:28 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,

Can anybody help me in explaining me what will be the time of duration between each insert/update .

Like for ex: I have a table and I'm inserting some 10 records into that . Is there any way where I can find the time gap/duration between each one insert and the other insert.

Regards,

Raj
Re: Insert duration [message #312628 is a reply to message #312624] Wed, 09 April 2008 08:36 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
ALTER SESSION SET SQL_TRACE=TRUE
The granular details can be extracted from the trace file if you know how to read it.
Re: Insert duration [message #312629 is a reply to message #312624] Wed, 09 April 2008 08:36 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Activate a trace and see the wait events.
It only depends on your application, Oracle waits for your next statement.

Regards
Michel
Previous Topic: csscan report advice
Next Topic: Application DEADLOCKS
Goto Forum:
  


Current Time: Thu Dec 08 19:51:46 CST 2016

Total time taken to generate the page: 0.09878 seconds