Home » Server Options » Replication » Everything is slow after recreating Snapshots
Everything is slow after recreating Snapshots [message #366459] Fri, 19 February 1999 13:11 Go to next message
Milan
Messages: 7
Registered: February 1999
Junior Member
hi,
we dropped andrecreated all snapshots (master tables are nowpretty big) and our snapshot site Oracle servers are since that operation very slow, doe's anybody
knows why, and what we can do to improve our performance.
thanx
Re: Everything is slow after recreating Snapshots [message #366509 is a reply to message #366459] Thu, 17 February 2000 17:40 Go to previous message
Sherry
Messages: 3
Registered: February 2000
Junior Member
http://www.oracle.com/oramag/oracle/98-Nov/68ornt.html

See "Deleting snapshot sites" paragraph #2.
--> Failure to inform the master about a deletion causes a gradual slowdown in all fast refreshes, because the master's snapshot log tables increase as they hold onto data that isn't replicated and therefore not replaced or updated.
Previous Topic: replicating - ommitting set of deletes
Next Topic: How Many DBLINKS?
Goto Forum:
  


Current Time: Mon May 16 07:34:25 CDT 2022