What parameters can be set to control Parallel Query?

The following INIT.ORA initialization parameters can be set to control Parallel Query execution:

  • PARALLEL_MIN_SERVERS

  • PARALLEL_MAX_SERVERS

  • PARALLEL_AUTOMATIC_TUNING = TRUE

    # enable intelligent defaults for parallel execution parameters (8i and above)

  • etc.