SQL> select * from v$mystat where rownum<2;
SIDSTATISTIC# VALUE
---------- ---------- ----------
858 0 0
SQL> select /*+ parallel(t 4)*/ count(*),agmt_id fromF_AGT_COMR_INTDIST_H t group by agmt_id;
出现9个进程
SQL> select * from v$mystat whererownum<2;
SID STATISTIC# VALUE
---------- ---------- ----------
860 0 0
SQL> select /*+ parallel(t 4)*/count(*),agmt_id from F_AGT_COMR_INTDIST_H t group by agmt_id order by agmt_id;
出现9个进程