Here is a recording available on Youtube of a session I did a while ago, covering how to understand the essentials of Oracle Parallel Execution and how to read the corresponding execution plans.
New JOIN TO ONE clause in 26.2 SELECT
1 week ago