Lutz Haake | Freelance Oracle Consultant

With parallel execution, displayed values for query duration and elapsed query time differ in OMS.

In SQL monitor, the execution time on the query is 1,8minutes = about 108 seconds.

SQL statistics show an elapsed time of 545s:

The parallel portions of the execution plan are cumulated over the individual parallel query slaves, while non-parallel steps are not. In the example, which was executed at a parallel degree of 8, the effective factor therefore computes to a lower value of around 5.