Database DataWarehousing (MOSC)

MOSC Banner

AutoDOP and Optimizer estimations

edited Aug 29, 2013 9:43PM in Database DataWarehousing (MOSC) 14 commentsAnswered
 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). 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center