what could cause a high elap value for the exec system call (for a select statement)?
Date: Tue, 3 Nov 2009 17:36:44 +0100
When investigating a performance problem using sql trace for a client, I came across a (huge) select statement, for which the elap value in the exec call was more then 4 seconds.
Does somebody know what can cause this? Are there any know bugs which can cause this behaviour (during tracing)? The tracing was done with both waits and binds enabled. The statement only had 2 bind variables. The db version is 10.2.0.4 on OEL 4.7
Oracle Database Administrator
tel +32(0)3 451 23 82