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博客 ” ，链接：https://blog.itpub.net/22034023/viewspace-1427083/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
