OCM 11g Preparation - Configure and use parallel execution for queries

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 👍!

Leave a Reply

Your email address will not be published.