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
> 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
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