ORACLE10G rac 两节点。在其中的一个节点在部署了流复制。这一节点上的响应时间比另一节点大很多。
下面是此节点的TOP5事件。
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
Streams capture: waiting for a 2,292 1,272 555 21.4 Other
CPU time 1,216 20.5
log file sequential read 19,246 254 13 4.3 System I/O
db file sequential read 22,077 161 7 2.7 User I/O
gcs log flush sync 40,867 79 2 1.3 Other
以下是与SQL ORDER BY READS
SQL ordered by Reads DB/Inst: BILLBJ/billbj2 Snaps: 7505-7506
-> Total Disk Reads: 24,716
-> Captured SQL account for 114.3% of Total
Reads CPU Elapsed
Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
9,295 39 238.3 37.6 423.97 523.03 2q0h3h6ptrcmx
INSERT INTO BANDWIDTHTABLE(ID,CHANNELID,BUSINESSTYPE,DAY,NODEID,DATA,INDATA,USER
ID,PARFLAG) values(BANDWIDTH_SEQUENCE.NEXTVAL,:1,:2,:3,:4,:5,:6,:7,:8)
9,235 204,146 0.0 37.4 46.64 70.95 ayxg8ajztf866
insert into system.logmnr_restart_ckpt$ (session#, valid, ckpt_scn, xidusn, xids
lt, xidsqn, session_num, serial_num, ckpt_info, flag, offset, client_data, spare
1) values (:1, 0, :2, :3, :4, :5, :6, :7, EMPTY_BLOB(), :8, 1, EMPTY_BLOB(), :9)
8,278 497,496 0.0 33.5 190.35 237.80 gdc5f827s4u6t
MERGE INTO BANDWIDTH_DAILYTABLE A USING (SELECT :B7 CHANNELID, :B6 BUSINESSTYPE,
:B5 DAY, :B4 NODEID, :B3 DATA, :B2 INDATA, :B1 USERID, :B8 PARFLAG FROM DUAL) T
ON (A.USERID = T.USERID AND A.PARFLAG = T.PARFLAG AND A.CHANNELID = T.CHANNELID
AND A.DAY = T.DAY AND A.NODEID = T.NODEID AND A.BUSINESSTYPE = T.BUSINESSTYPE)
我感觉这个问题跟流复制有很大的关系,但不知原因,谁清楚的?
下面是此节点的TOP5事件。
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
Streams capture: waiting for a 2,292 1,272 555 21.4 Other
CPU time 1,216 20.5
log file sequential read 19,246 254 13 4.3 System I/O
db file sequential read 22,077 161 7 2.7 User I/O
gcs log flush sync 40,867 79 2 1.3 Other
以下是与SQL ORDER BY READS
SQL ordered by Reads DB/Inst: BILLBJ/billbj2 Snaps: 7505-7506
-> Total Disk Reads: 24,716
-> Captured SQL account for 114.3% of Total
Reads CPU Elapsed
Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
9,295 39 238.3 37.6 423.97 523.03 2q0h3h6ptrcmx
INSERT INTO BANDWIDTHTABLE(ID,CHANNELID,BUSINESSTYPE,DAY,NODEID,DATA,INDATA,USER
ID,PARFLAG) values(BANDWIDTH_SEQUENCE.NEXTVAL,:1,:2,:3,:4,:5,:6,:7,:8)
9,235 204,146 0.0 37.4 46.64 70.95 ayxg8ajztf866
insert into system.logmnr_restart_ckpt$ (session#, valid, ckpt_scn, xidusn, xids
lt, xidsqn, session_num, serial_num, ckpt_info, flag, offset, client_data, spare
1) values (:1, 0, :2, :3, :4, :5, :6, :7, EMPTY_BLOB(), :8, 1, EMPTY_BLOB(), :9)
8,278 497,496 0.0 33.5 190.35 237.80 gdc5f827s4u6t
MERGE INTO BANDWIDTH_DAILYTABLE A USING (SELECT :B7 CHANNELID, :B6 BUSINESSTYPE,
:B5 DAY, :B4 NODEID, :B3 DATA, :B2 INDATA, :B1 USERID, :B8 PARFLAG FROM DUAL) T
ON (A.USERID = T.USERID AND A.PARFLAG = T.PARFLAG AND A.CHANNELID = T.CHANNELID
AND A.DAY = T.DAY AND A.NODEID = T.NODEID AND A.BUSINESSTYPE = T.BUSINESSTYPE)
我感觉这个问题跟流复制有很大的关系,但不知原因,谁清楚的?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9375/viewspace-555153/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9375/viewspace-555153/