Database Tuning (MOSC)

MOSC Banner

AWR Captured SQL accounts

edited Jan 10, 2017 10:52AM in Database Tuning (MOSC) 16 commentsAnswered ✓

Hi,

Please can you help me to understand the differences between "Total DB time" and Elapsed Time in the SQL ordered by Elapsed Time section of an AWR, for example:

In this example we have:

- (A) DBtime: 47.310 seconds

- (B) Sum of the Elapsed time (s) column: 48.843.

- AWR Elapsed time it is 60 minutes.

- Captured SQL Accounts 57,4% and PLS/SQL 57,3% => I have an heterogeneus load on my instance and only 57% of the SQL/PL/SQL persist in the shared pool after one hour activity.

Please can you help me to undertand, why the "Sum of the elapsed time" it is similar to the DBTime if only 57% of the PL/SQL - SQL has been captured in the snapshoot period?

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