sql awr numbers not matching
Hi,
I am finding discrepancy between elapsed time value and timing in execution plan in .
values are mentioned below:-
Elapsed Time (ms)==> 9,398.95 ms (i.e., 9.3s)
but execution plan showing below:-
0 SELECT STATEMENT 97475 (100)
1 SORT ORDER BY 377K 188M 226M 97475 (1) 00:19:30
2 TABLE ACCESS FULL F98865 377K 188M 55666 (1) 00:11:0
so, from execution plan, elapsed time should have been 19:30+11:00=30 minutes.
I believe both the values for samples execution over same time period, how can they be so different?