very inefficient refresh of snapshots

From: Juergen Palkoska <jp_at_faw.uni-linz.ac.at>
Date: Wed, 27 Oct 1999 18:37:57 +0200
Message-ID: <38172A65.EA12497A@faw.uni-linz.ac.at>

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 - 11:37:57 CDT