OraFAQ Forum: Replication » Everything is slow after recreating Snapshots

Home » Server Options » Replication » Everything is slow after recreating Snapshots

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Everything is slow after recreating Snapshots [message #366459]

Fri, 19 February 1999 13:11

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

Report message to a moderator

Re: Everything is slow after recreating Snapshots [message #366509 is a reply to message #366459]

Thu, 17 February 2000 17:40

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.

Report message to a moderator

Previous Topic:	replicating - ommitting set of deletes
Next Topic:	How Many DBLINKS?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 25 14:25:59 CDT 2026