Oracle 并行查询 - 如何找出实际产生的进程数？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1420019/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle parallel query - How to find out actual number of spawned processes?
提问by Sergey Stadnik
I am using Oracle parallel queryfeature on a 10G 3-node RAC where each node is a 16-CPU machine. The question is, how can I see the actualnumber of Oracle processes spawned to execute the query on all 3 nodes?
我在 10G 3 节点 RAC 上使用Oracle 并行查询功能，其中每个节点都是 16 个 CPU 的机器。问题是，我如何才能看到为在所有 3 个节点上执行查询而产生的 Oracle 进程的实际数量？
回答by Sergey Stadnik
I found it in this article:
我在这篇文章中找到了它：
First, find out the ID and serial# of the current session:
首先，找出当前会话的 ID 和序列号：
SELECT paddr, sid, serial# FROM v$session WHERE audsid = userenv('sessionid')
SELECT paddr, sid, serial# FROM v$session WHERE audsid = userenv('sessionid')
Then to see the parallel execution servers that are dedicated to that session:
然后查看专用于该会话的并行执行服务器：
SELECT qcsid, qcserial#, SID, serial#, server#, degreeFROM gv$px_session pxsWHERE pxs.qcsid = :your_sid AND pxs.qcserial# = :your_serial
SELECT qcsid, qcserial#, SID, serial#, server#, degreeFROM gv$px_session pxsWHERE pxs.qcsid = :your_sid AND pxs.qcserial# = :your_serial
