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

From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
To: "Oracle-L@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 3 Nov 2009 17:36:44 +0100

Hi,

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


Regards,
 
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer



--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- RE: what could cause a high elap value for the exec system call (for a select statement)?
  - From: Allen, Brandon
- Re: what could cause a high elap value for the exec system call (for a select statement)?
  - From: Tim Gorman
- Re: what could cause a high elap value for the exec system call (for a select statement)?
  - From: Daniel Fink

Other related posts:

» what could cause a high elap value for the exec system call (for a select statement)? - D'Hooge Freek
» RE: what could cause a high elap value for the exec system call (for a select statement)?- Allen, Brandon
» Re: what could cause a high elap value for the exec system call (for a select statement)?- Tim Gorman
» Re: what could cause a high elap value for the exec system call (for a select statement)?- Daniel Fink
» RE: what could cause a high elap value for the exec system call (for a select statement)?- D'Hooge Freek
» RE: what could cause a high elap value for the exec system call (for a select statement)?- Mark W. Farnham
» RE: what could cause a high elap value for the exec system call (for a select statement)?- D'Hooge Freek
» Re: what could cause a high elap value for the exec system call (for a select statement)?- Cary Millsap
» RE: what could cause a high elap value for the exec system call (for a select statement)?- D'Hooge Freek
» Re: what could cause a high elap value for the exec system call (for a select statement)?- Tim Gorman
» RE: what could cause a high elap value for the exec system call (for a select statement)?- D'Hooge Freek
» RE: what could cause a high elap value for the exec system call (for a select statement)?- Mark W. Farnham
» RE: what could cause a high elap value for the exec system call (for a select statement)?- Ric Van Dyke
» Re: what could cause a high elap value for the exec system call (for a select statement)?- Tim Gorman
» RE: what could cause a high elap value for the exec system call (for a select statement)?- D'Hooge Freek
» RE: what could cause a high elap value for the exec system call (for a select statement)?- D'Hooge Freek