snapshots question

From: Carole Turney <cturney_at_cts.ucla.edu>
Date: Thu, 16 Apr 1998 14:35:59 -0800
Message-ID: <353679BF.F2CFD276@cts.ucla.edu>

Hi,

We're running Oracle 7.3.4 on two Sun servers. One server is our production machine, and we want to be able to duplicate, in read-only mode, the tables to the second machine to offload system resources for users who only need to look at, not change the data.

Simple snapshots look like they *should* do the trick nicely (at least in theory). I figured we'd have to play with time intervals to find optimal refresh times. Are there any other alternatives which may work just as well (or better)? Anyone have any experience/advice with snapshots with gotcha info?

thanks in advance,
Carole (cturney_at_cts.ucla.edu) Received on Thu Apr 16 1998 - 17:35:59 CDT