Analyze AWR understand difference between times cpu and elapsed
hello,
i have a problem timesout, with ora-3113/3114 during a treatment ETL. then during this time i executed a AWR. and i see a high time difference between cpu and elapsed.
cpu time = 3,65 and elapsed 191,30
i would like understand the difference between the 2 time and where i can see this diffrence.
i join you the AWR report.
best regards
JP
CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|
3.65 | 1 | 3.65 | 2.76 | 191.30 | 1.91 | 98.46 | azw5n5n45mkjp | al_engine.exe | SELECT "AP_INVOICE_LINES_ALL".... |