Database Tuning (MOSC)

MOSC Banner

AWR report analysis

edited Mar 30, 2009 10:05PM in Database Tuning (MOSC) 2 commentsAnswered
 Hello All
I have the following problem:

When I create an awr report within two snapshots say 24139 and 24140 , I get from the part of "SQL ordered by Elapsed Time" the following information:

SQL ordered by Elapsed Time DB/Inst: DEVC/DEVC Snaps: 24139-24140
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
into the Total Database Time multiplied by 100


OUTPUT



Elapsed    CPU                                  Elap per     % Total
Time (s)     Time (s)     Executions       Exec (s)      DB Time         SQL Id
39             39               2                       19.7         14.4             dccxnr2d9b3xd

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