Re: Any experience with Oracle Snapshots?

Oracle snapshot work quite nicely. I have not been able to determine any impact on the source system created by the snapshot log. The automatic refresh works very reliably as well.

Extract and load scripts would not be as fast as the refresh process. Esecially if using the fast refresh option. Extracting and loading the data will give you the increased overhead of writting the data to disk.

Comparing it to backup and restore of the entire instance... Considerably faster. Again, the fast refreshes will only send the rows which have changed.

Chris Hardison wrote:
>
> I would like to hear about anyone's experience with Oracle Snapshots.
> Do they work as advertised? Is the perfomance better than if we
> implemented using a series of extract and load scripts? Does the
> snapshot log affect performance of the source system? How does
> performance compare with backup and restore from duplicating an entire
> schema (or does Oracle backup and restore entire instance)? Does the
> automatic refresh work well (as advertised)? Any other comments on
> Oracle snapshots?
>
> Thanks in advance for any feedback!!
> chris
Received on Fri Oct 30 1998 - 14:18:30 CST