AWR Captured SQL accounts
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?