AutoDOP and Optimizer estimations
Hi all !
I am having a strange problem with the optimized and AutoDOP...
First, my version of oracle is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production on Windows on a 4 CPU box.
I have enabled Parallel processing according to the new 11.2 way, and it seems to be working most of the time for queries where I put the /*+ parallel */ hint :
Note
-----
- automatic DOP: Computed Degree of Parallelism is 2
15 rows selected.
One of the developers came to me and asked my why his statement doesn't take advantage of the parallel execution and takes sooo long to run (like ~ 300 seconds).
0