2节点RAC,t_one表的所有块的master都是节点2,11.2.0.3
清空buffer_cache
然后在节点1执行:
execute snap_events.start_snap
update t_one set v1='10';
execute snap_events.end_snap
SID: 237:TEST - oracle
Session Events - 05-2月 10:47:33
Interval:- 0 seconds
---------------------------------------------------------
Event Waits Time_outs Csec Avg Csec Max Csec
----- ----- --------- ---- -------- --------
Disk file operations I/O 2 0 0 .001 0
KSV master wait 2 0 0 .084 0
db file sequential read 5 0 1 .288 1
db file scattered read 2 0 0 .043 0
gc cr grant 2-way 1 0 0 .045 0
row cache lock 5 0 0 .040 0
SQL*Net message to client 4 0 0 .000 0
SQL*Net message from client 4 0 0 .037 1,344
events in waitclass Other 1 0 0 .004 0
等待事件是: gc cr grant 2-way ,而不是gc current grant 2-way ,不知道原因,留作疑问。
清空buffer_cache
然后在节点1执行:
execute snap_events.start_snap
update t_one set v1='10';
execute snap_events.end_snap
SID: 237:TEST - oracle
Session Events - 05-2月 10:47:33
Interval:- 0 seconds
---------------------------------------------------------
Event Waits Time_outs Csec Avg Csec Max Csec
----- ----- --------- ---- -------- --------
Disk file operations I/O 2 0 0 .001 0
KSV master wait 2 0 0 .084 0
db file sequential read 5 0 1 .288 1
db file scattered read 2 0 0 .043 0
gc cr grant 2-way 1 0 0 .045 0
row cache lock 5 0 0 .040 0
SQL*Net message to client 4 0 0 .000 0
SQL*Net message from client 4 0 0 .037 1,344
events in waitclass Other 1 0 0 .004 0
等待事件是: gc cr grant 2-way ,而不是gc current grant 2-way ,不知道原因,留作疑问。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22034023/viewspace-1427083/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22034023/viewspace-1427083/