| Fast Replication is slow [message #443430] |
Mon, 15 February 2010 13:36  |
patjose
Messages: 12
Registered: January 2010
|
Junior Member |
|
|
QUERY_REWRITE_ENABLED=true on replication site (DB2).
Simple Materialized View FAST replication of just ONE table from DB1 to DB2. The Master table in DB1 has 900K records, done an update which updates around 130K records ( So 130K records in MLOG$ of Materialized View in DB1) . Complete refresh is done in 27 seconds, but FAST refresh for this activity is taking 2 hours and j001 background process is taking 100% of CPU for all these 2 hours. If the update is for 5-6 records, this refresh would be done in 2-3 seconds
Traced the session for waits and tkprof output is attached, how can I improve the FAST refresh?
Thanks!
-
Attachment: test1.txt
(Size: 4.99KB, Downloaded 2413 times)
[Updated on: Mon, 15 February 2010 13:38] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
