Influencing commit interval of read-only replication's refresh gr

2001-06-29 Thread Szecsy Tamas
Hi, does some one know of a way to force the refresh process of a read-only snapshot group to commit at predefined intervals: by table, by n number of rows or any other way? The problem that we are facing is that a refresh group has some rapidly changing tables and the rollback segment is not big

Re: Influencing commit interval of read-only replication's refresh gr

2001-06-29 Thread Stephane Faroult
> Hi, > > does some one know of a way to force the refresh process of a read-only > snapshot group to commit at predefined intervals: by table, by n number of > rows or any other way? The problem that we are facing is that a refresh > group has some rapidly changing tables and the rollback segme

Re: Influencing commit interval of read-only replication's refresh gr

2001-07-02 Thread A. Bardeen
Tamas, The purpose of the refresh is to make the snapshot site identical to the master site as of the point in time that the refresh began. As such the refresh is a single transaction and must either commit or rollback in its entirety. You don't specify what version the snapshot site is, but on