Oracle 查看sql开几个并行
一讨论群的朋友问到：怎么查看sql 开几个并行 ？
如果这个问题问您，除了肉眼看 sql，PARALLEL是几以外还有其他方案么？
SQL> set autot trace exp
SQL> select /*+ PARALLEL(8) */ count (1 ) from es_ins_rec;
Execution Plan
----------------------------------------------------------
Plan hash value: 3542243435
--------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time | TQ |IN-OUT| PQ Distrib |
----------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 8834 (3)| 00:00:18 | | | |
| 1 | SORT AGGREGATE | | 1 | | | | | |
| 2 | PX COORDINATOR | | | | | | | |
| 3 | PX SEND QC (RANDOM) | :TQ10000 | 1 | | | Q1,00 | P->S | QC (RAND) |
| 4 | SORT AGGREGATE | | 1 | | | Q1,00 | PCWP | |
| 5 | PX BLOCK ITERATOR | | 83M| 8834 (3)| 00:00:18 | Q1,00 | PCWC | |
| 6 | INDEX FAST FULL SCAN| PK_ES_INS_REC | 83M| 8834 (3)| 00:00:18 | Q1,00 | PCWP | |
----------------------------------------------------------------------------------------------------------------
Note
-----
- Degree of Parallelism is 8 because of hint
SQL>
SQL> select /*+ PARALLEL(8) */ count (1 ) from es_ins_rec;
Execution Plan
----------------------------------------------------------
Plan hash value: 3542243435
--------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time | TQ |IN-OUT| PQ Distrib |
----------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 8834 (3)| 00:00:18 | | | |
| 1 | SORT AGGREGATE | | 1 | | | | | |
| 2 | PX COORDINATOR | | | | | | | |
| 3 | PX SEND QC (RANDOM) | :TQ10000 | 1 | | | Q1,00 | P->S | QC (RAND) |
| 4 | SORT AGGREGATE | | 1 | | | Q1,00 | PCWP | |
| 5 | PX BLOCK ITERATOR | | 83M| 8834 (3)| 00:00:18 | Q1,00 | PCWC | |
| 6 | INDEX FAST FULL SCAN| PK_ES_INS_REC | 83M| 8834 (3)| 00:00:18 | Q1,00 | PCWP | |
----------------------------------------------------------------------------------------------------------------
Note
-----
- Degree of Parallelism is 8 because of hint
SQL>
并行度其他写法：
INSERT /*+ parallel(t 8) */ INTO es_ins_rect 【注意： /*+ pa.. 有没有空格都可以】
咳咳,,貌似没多大意义的样子!! 可以当复习了...
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28211342/viewspace-2136747/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
