oracle并行会快多少,oracle PARALLEL 并行执行会对cpu 造成很大的压力吗？

WITH T1 AS (SELECT /*+PARALLEL(S,4)*/  S.BUSI_TACHE,

CASE

WHEN S.FAILURE_REASON = '210023' THEN

1

ELSE

0

END CC,

CASE

WHEN S.FAILURE_REASON IS NOT NULL AND

S.FAILURE_REASON != '210023' THEN

1

ELSE

0

END XX,

S.BUSI_SERIAL_NO

FROM IRCNDBA.IO_SUBCHG_ORDER_TACHE  S

WHERE S.TACHE_DEAL_TM >=

TO_DATE('20180523080000', 'yyyy/MM/dd HH24:mi:ss')),

T2 AS

(SELECT /*+PARALLEL(S1,4)*/ S1.PROV_CD,

S1.CHANNEL_CD,

S1.BUSI_SERIAL_NO,

S1.PRODUCT_ID,

S1.INTF_LOG_ID

FROM IRCNDBA.IO_SUBCHG_ORDER    S1

WHERE S1.LAST_MOD_TM BETWEEN

TO_DATE('20180523080000', 'yyyy/MM/dd HH24:mi:ss') AND

TO_DATE('20180523083000', 'yyyy/MM/dd HH24:mi:ss')),

T3 AS

(SELECT /*+PARALLEL(S3,4)*/ S3.SMS_ID, MAX(S3.REDO_TIMES) MAX_REDO

FROM IRCNDBA.IO_SUBCHG_SMS_SEND_LOG    S3

WHERE S3.SEND_TM >= TO_DATE('20180523080000', 'yyyy/MM/dd HH24:mi:ss')

GROUP BY S3.SMS_ID),

T41 AS

(SELECT /*+PARALLEL(T2,4)(T1,4)*/ T2.PROV_CD,

T2.CHANNEL_CD,

T6.PRODUCT_CATEGORY,

T1.CC,

T1.XX,

T1.BUSI_TACHE

FROM T2, IRCNDBA.IO_SUBCHG_PRODUCT T6, T1

WHERE T2.PRODUCT_ID = T6.PRODUCT_ID

AND T2.BUSI_SERIAL_NO = T1.BUSI_SERIAL_NO)

SELECT /*+PARALLEL(T2,4)(T5, 4)*/  T2.PROV_CD,

T2.CHANNEL_CD,

'SMS' CHANNEL_CD,

COUNT(1) BUSINESS,

SUM(CASE

WHEN T5.STATUS = 3 THEN

1

ELSE

0

END) BUSINESREASON,

0 SYSREASON

FROM T2,

(SELECT T4.STATUS, T4.RELA_ID

FROM T3, IRCNDBA.IO_SUBCHG_SMS_SEND_LOG    T4

WHERE T4.SMS_ID = T3.SMS_ID

AND T4.REDO_TIMES = T3.MAX_REDO) T5

WHERE T2.INTF_LOG_ID = T5.RELA_ID

GROUP BY T2.PROV_CD,T2.CHANNEL_CD

UNION ALL

SELECT /*+PARALLEL(T6, 4)*/  T6.PROV_CD,

T6.CHANNEL_CD,

T6.PRODUCT_CATEGORY,

COUNT(1) BUSINESS,

SUM(T6.CC) SYSREASON,

SUM(T6.XX) BUSINESREASON

FROM (SELECT T41.PROV_CD,T41.CHANNEL_CD, T41.PRODUCT_CATEGORY, T41.CC, T41.XX

FROM T41

UNION ALL

SELECT T41.PROV_CD,T41.CHANNEL_CD, T41.PRODUCT_CATEGORY, T41.CC, T41.XX

FROM T41

WHERE T41.BUSI_TACHE IN ('1010',   '1030', '1090',  '1110', '1130',   '1190',    '2105',  '2110',   '2130',  '2135',   '2140',  '2160',   '2180',  '2190',  '2295',  '2390', '2395')) T6

GROUP BY T6.PROV_CD,T6.CHANNEL_CD, T6.PRODUCT_CATEGORY;

SQL如上， 在建立临时表的时候查询就有用到PARALLEL, 在后面对临时表的统计中又再次用到了PARALLEL，这样会对cpu造成很大的压力吗？求大神指点。