3 Replies Latest reply: Jan 29, 2013 2:06 PM by garywicke RSS

    /*+ parallel (8) */ - how many process will be spawned?

    garywicke
      Environment:

      Oracle 11.2.0.3 EE on Solaris 5.10

      If I place the above hint in a SELECT statement, how many server processes will be spawned?

      In looking at V$PX_SESSION I see 16, 8 under SERVER_SET 1 and another 8 under SERVER_SET 2.

      Is this saying there are 8 producers and 8 consumers?

      I can't seem to find the definition of a SERVER_SET and how it's used in a PQ environment.

      Any feedback and references to documentation is greatly appreciated.

      Thanks very much!

      -gary