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.
RandolfGeist, Independent consultant Oracle performance troubleshooting Database design for good performance In-house seminars and workshops for developers - application design for performance and scalability