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.
Testing DEFAULT ON NULL FOR UPDATE in 23ai
3 hours ago