Parallel executions are there since Oracle 8 Parallel Server. The documentation linked below is worth reading. It gives you an overall idea.
For this topic, I recommend you to have a good knowledge about each parallel parameter.
- Type "show parameter parallel" and understand very well each of them.
- Check parallel performance and informations via v$px and v$pq dictionary views.
- Change default object parallelism degree.
- Force parallel usage via hints.
- Alter session and set parallel QUERY / DDL / DML.
Path to Documentation:
VLDB and Partitioning Guide -> 8 Using Parallel Execution
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!