Setup, Monitor, And Tune Parallelism In The Database
(Doc ID 1549214.1)
Last updated on DECEMBER 27, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.2.0.1 [Release 11.2 to 12.2] Oracle Database Configuration Assistant - Version 12.1.0.2 to 12.1.0.2 [Release 12.1] Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later Information in this document applies to any platform.
Purpose
As with many tune-able options in Oracle, what works best in one environment may not be the best for another. This is certainly true when setting up and configuring parallelism in the database. In addition to properly setting database parameters, parallel execution performance is impacted by the availability of system resources, specifically IO, CPU, and memory. It's always good practice to start with the default values when first setting up parallelism. Determine if these setting are sufficient before making any changes.
Scope
DBAs that want to view, monitor, and tune parallel execution parameters.
Details
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
