Re: very inefficient refresh of snapshots

Do they need to refresh as a single group? What you're telling us there is that the tables need to refresh together, which is fine if they have referential integrity between them, but is otherwise unnecessary.

Also, you should look at things like the rollback segment being used, degree of parallelization etc.

HTH. Pete

Juergen Palkoska wrote:

> Hi,
> we have configured a replication from an Oracle 8.1.5 to an
> Oracle 8.0.4 server.
>
> For this purpose we have defined 11 simple fast refresh snapshots,
> some of them holding only a few records and some of them holding
> about 200,000 records.
>
> The snapshots are organized within one single refresh-group.
>
> The problem is the following: Even if only one single record is
> modified, the refresh-operation of the group runs between 5 and
> 15 minutes.
>
> Has anybody an idea what could be wrong configured, so that the
> refresh process is running so inefficiently?
>
> Best regards,
> Juergen

Received on Wed Oct 27 1999 - 13:51:57 CDT