1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

properly tune parallel parameters?

Discussion in 'Server Administration and Options' started by tomsonkh, Jun 1, 2015.

  1. tomsonkh

    tomsonkh Guest

    how to properly tune parallel parameters in oracle database such as:

    parallel_execution_message_size, parallel_min_percent, parallel_min_servers??
     
  2. ocprep

    ocprep Forum Advisor

    Messages:
    277
    Likes Received:
    76
    Trophy Points:
    410
    Location:
    Orlando, Florida
    All of these parameters -- indeed all of parallelization in Oracle -- is highly dependent on your hardware and especially on how much unused server resources are available. If your server is constantly running at 90% utilization, for example, and you start parallelizing queries, your overall performance is almost certain to go down rather than up.