Database Tuning (MOSC)

MOSC Banner

Analyze AWR understand difference between times cpu and elapsed

edited Dec 4, 2015 10:03AM in Database Tuning (MOSC) 5 commentsAnswered

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)%TotalElapsed Time (s)%CPU%IOSQL IdSQL ModuleSQL Text

3.6513.652.76191.301.9198.46azw5n5n45mkjpal_engine.exe SELECT "AP_INVOICE_LINES_ALL"....
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center