Insert duration [message #312624] |
Wed, 09 April 2008 08:28 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #312629 is a reply to message #312624] |
Wed, 09 April 2008 08:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|