What exactly does the DBMonitor Duration Column measure?

[Andew]

Hi,

I am trying to work out why our client is saying that a previous version of our application is faster than our current version. The current build uses ODAC where the previous version used BDE.

We cannot replicate the problem on our servers with a copy of their database so we believe the problem may be a hardware problem. However we need to prove it to the dissatisfied customer.

We are using DBMonitor to check the timing of queries etc.

Can you tell me exactly what the duration measures in DBmonitor.

Is it the time to execute the query on the oracle database or does it include the time for the data packet to reach the middle tier appserver and the ODAC component?


Thanks for your help

Andrew

[Alex]

DbMonitor measures time elapsed between Before and After events, that raises inside ODAC components, so Duration column represents the duration between start and end of measurement event on the client (ODAC) side.