SQL> select /*+ parallel */ count(*) from t1;
COUNT(*)
----------
31375
SQL> select * from v$pq_sesstat where statistic='Allocation Height';
STATISTIC LAST_QUERY SESSION_TOTAL
------------------------------------------------------------ ---------- -------------
Allocation Height 2 0
能够看到该语句实际运行的并行度为2
COUNT(*)
----------
31375
SQL> select * from v$pq_sesstat where statistic='Allocation Height';
STATISTIC LAST_QUERY SESSION_TOTAL
------------------------------------------------------------ ---------- -------------
Allocation Height 2 0
能够看到该语句实际运行的并行度为2
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25702/viewspace-767489/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25702/viewspace-767489/