Welcome to part 6 of the series. The USE_PARTITION_WISE_GBY hint is “brand new,” introduced in 12.2. I personally welcome this hint as I’ve cursed many times in the past due to the lack of control for this aspect of parallelism…
Read More >Parallel execution in Oracle seems to be a topic of myths, mysteries and misunderstandings. In this post I hope to clear up at least one of them by diving into a discussion about parallel DML. Actually, I want to show…
Read More >Christo Kutrovsky, ATCG Principal Consultant and Oracle ACE at Pythian, shares something useful he discovered by accident when playing with Auto DOP.
Read More >