what could cause a high elap value for the exec system call (for a select statement)?

From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Tue, 3 Nov 2009 17:36:44 +0100
Message-ID: <4814386347E41145AAE79139EAA398980D33E9FB57_at_ws03-exch07.iconos.be>


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.

EXEC #39:c=4263352,e=4204874,p=0,cr=66,cu=0,mis=1,r=0,dep=0,og=1,tim=1226849067232845

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 on OEL 4.7

Freek D'Hooge
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
disclaimer: www.uptime.be/disclaimer

Received on Tue Nov 03 2009 - 10:36:44 CST

Original text of this message