oracle对cpu会有限制吗,oracle PARALLEL SQL这样执行会对cpu造成很大的压力吗?

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

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;