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:
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
dbMonitor Duration
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: dbMonitor Duration
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?
It takes our dbMonitor approximately 20 seconds to process this command.
Command execution time displayed is not always the actual one. Try executing the following code:PatrikAhlquist wrote:It's always a small value between Prepare and Execute
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();