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

Report message to a moderator

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: 26766
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.

Report message to a moderator

Re: Insert duration [message #312629 is a reply to message #312624] Wed, 09 April 2008 08:36 Go to previous message
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 06 16:51:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.