Re: How to automatically Refresh snapshots ?

From: ykhogaly <ykhogaly_at_us.oracle.com>
Date: Thu, 23 Dec 1999 20:50:44 -0700
Message-ID: <83un0v$h5$1@inet16.us.oracle.com>

Make sure the following parameters are set to ensure SNP background processes are available. JOB_QUEUE_PROCESSES = 1 (must have a least on SNP background process) JOB_QUEUE_INTERVAL = 60 (default)
Make sure the snapshot is within a snapshot group if it already does not belong in one. NOTE: A snapshot created with a refresh interval is already a group. 3) Create a procedure on the snapshot site containing DBMS_REFRESH.CHANGE.

Example:

  Create procedure rfrsh as
  begin
  DBMS_REFRESH.CHANGE('',sysdate);
  end;
  /

4) Execute the remote procedure. execute rfrsh_at_database_link

5) Issue a commit.

The refresh may not take affect immediatly. Once the SNP background process wakes up it will notice the snapshot's next refresh time has changed and refresh the snapshot. The smaller the value for JOB_QUEUE_INTERVAL, the quicker the snapshot will refresh.

"The Views expressed here are my own and not necessarily those of Oracle Corporation"

"Xavier Darcos" <xdarcos_at_astek.fr> wrote in message news:386240C1.6C89505B_at_astek.fr...
> Hi,
>
> I've created a refresh group (following the advice of Lars Bo vanting)
> to refresh my snapshots on a remote database.
>
> But when I use the following :
>
> DBMS_REFRESH.CHANGE('MyRefreshGroup',Sysdate,NULL) to force the refresh,
> it doesn't refresh my snapshots.
>
> Even when I created the refresh group with the interval "Sysdate +
> 1/48", half an hour later, my snapshots were not refreshed.
>
> So, How ?
>
> Thanks a lot
>
> Xavier
Received on Thu Dec 23 1999 - 21:50:44 CST