Re: Snapshots/refresh/frequency

You want to make sure that the interval you specify is long enough for the refresh to actually take place and complete. If you try a refresh interval of every minute and it takes a significant portion of that one minute for the refresh to run, you'll have problems.

Time your snapshot refresh by setting the snapshot up without a refresh interval, then refresh it manually using the dbms.snapshot stored procedure. Once you have a good feel of how long it takes (over several executions), give it plenty of breathing room when you set the refresh interval.

In article <4tbsde$vl_at_abel.cc.sunysb.edu>, rich_at_sbrich.ic.sunysb.edu says...
>
>
>I'm considering using the snapshot facility
>to replicate a portion of a table, but want
>to keep the tables sync'd up using a low
>value for the refresh interval. Does anyone
>have experience with how frequently the
>replication can occur? i.e. every second?
>
>Any practical information appreciated.
>
>Rich Neill
>SUNY at SB
Received on Thu Aug 01 1996 - 00:00:00 CEST