dbMonitor Duration

dbMonitor Duration

Postby PatrikAhlquist » Wed 09 Jan 2013 09:43

About the duration column in dbMonitor.
It's always a small value between Prepare and Execute, even though I can clearly tell that the execute operation is taking much longer.

Like this:
Image
But if I copy the question and run it in Oracle SQL Developer it takes almost 30 seconds!

So, am I not understanding what duration is?

Regards,
Patrik
PatrikAhlquist
 
Posts: 21
Joined: Thu 11 Feb 2010 08:40

Re: dbMonitor Duration

Postby Pinturiccio » Fri 11 Jan 2013 15:37

The performance of dotConnect for Oracle and Oracle SQL Developer differs. Try creating a simple console application that would execute only your query. How long does it take to execute the query? Is it 30 seconds or less than a second?

PatrikAhlquist wrote:It's always a small value between Prepare and Execute

Command execution time displayed is not always the actual one. Try executing the following code:
Code: Select all
OracleMonitor mon = new OracleMonitor() { IsActive = true };
OracleConnection conn = new OracleConnection("your connection string");
conn.Open();
OracleCommand comm = new OracleCommand("BEGIN DBMS_LOCK.sleep(20); end;", conn);
comm.ExecuteNonQuery();
conn.Close();

It takes our dbMonitor approximately 20 seconds to process this command.
Pinturiccio
Devart Team
 
Posts: 1891
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle