title: Oracle parallel query - How to find out actual number of spawned processes?
body: <p>I am using <a href="http://www.akadia.com/services/ora_parallel_processing.html" rel="noreferrer">Oracle parallel query</a> feature on a 10G 3-node RAC where each node is a 16-CPU machine.
  The question is, how can I see the <strong>actual</strong> number of Oracle processes spawned to execute the query on all 3 nodes?</p>