两套oracle rac(都是双节点)间配置单向goldengate ,引起源数据库cluster和commit等待?
itpub上问了好几天了,没有消息;请大家帮忙看看;
环境描述: oracle 11.2.0.3.0
配置的是rac 到 rac 的golden gate
现在的情况是我在源端的rac上面其中一个节点配置好了golden gate,然后只要把 mgr 和extract进程一启动,源端这套rac 就产生集群竞争
节点1
Top 5 Timed Foreground Events
Event Waits Time(s) Avg wait (ms) % DB time Wait Class
gc buffer busy acquire 4,135,600 165,992 40 44.86 Cluster
gc buffer busy release 287,784 68,191 237 18.43 Cluster
DB CPU 62,867 16.99
gc current block busy 48,660 21,888 450 5.92 Cluster
gc cr block busy 97,452 20,355 209 5.50 Cluster
节点2
Top 5 Timed Foreground Events
Event Waits Time(s) Avg wait (ms) % DB time Wait Class
gc buffer busy release 302,966 103,756 342 29.20 Cluster
log file sync 200,671 101,667 507 28.61 Commit
DB CPU 76,431 21.51
enq: TX - index contention 66,425 29,722 447 8.36 Concurrency
gc buffer busy acquire 3,817,474 18,154 5 5.11 Cluster
这是当时启动extract进程后,分析源端rac的awr
extract 配置文件如下:
extract eora
dynamicresolution
userid ggs,password ggs
exttrail /home/oracle/ggs/dirdat/et
tranlogoptions altarchivelogdest instance emsdb2 +DATA1,altarchivelogdest instance emsdb1 +DATA1
tranlogoptions asmuser sys@ASMO_2,asmpassword hollycrm
table cp_bill.lee_ggs; |
|