Higher elapssed time when running in parallel than without
Hi!
I tested setting parallel_degree_policy to auto and watched a query which run in parallel but dont get how to interpret the much higher elapsed time in awr.
The query run for 31 sec without parallel and 2 sec with parallel so it went a lot faster but elapsed time is lower without parallel?
Someone who can give me an explanation?
/Johan
| Stat Name | Statement Total | Per Execution | % Snap Total |
|---|---|---|---|
| Elapsed Time (ms) | 31,555 | 31,554.67 | 0.32 |
| CPU Time (ms) | 21,129 | 21,128.79 | 1.14 |
| Executions | 1 | ||
| Buffer Gets | 1,023,242 | 1,023,242.00 | 1.77 |
| Disk Reads | 1,023,111 | 1,023,111.00 | 2.22 |
| Parse Calls | 1 | 1.00 | 0.01 |
| Rows | 1 | 1.00 | |
| User I/O Wait Time (ms) | 18,189 |
| Id | Operation | Name | Rows | Bytes | Cost (%CPU) | Time |
|---|---|---|---|---|---|---|
| 0 | SELECT STATEMENT |
0