Home » Server Options » Replication » Fast Replication is slow ( Oracle10.2.0.3, AIX5.3)
Fast Replication is slow [message #443430] Mon, 15 February 2010 13:36 Go to next message
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 1904 times)

[Updated on: Mon, 15 February 2010 13:38]

Report message to a moderator

Re: Fast Replication is slow [message #444501 is a reply to message #443430] Mon, 22 February 2010 05:05 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Post job_queue_processes parameter value

- Babu

Re: Fast Replication is slow [message #445263 is a reply to message #444501] Fri, 26 February 2010 17:33 Go to previous messageGo to next message
patjose
Messages: 12
Registered: January 2010
Junior Member
Issue is solved.

Primary key indexes were missing on this env for some reason. Once it's created the issue is resolved..

Thanks Babu anyway!
Re: Fast Replication is slow [message #445580 is a reply to message #445263] Tue, 02 March 2010 14:24 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Thanks for your feedback.

Babu
Previous Topic: Creative conflict resolution
Next Topic: Materialized Views Refresh in SnapshotGroup
Goto Forum:
  


Current Time: Thu Mar 28 14:10:52 CDT 2024