Re: HELP! HOW TO REFRESH A SNAPSHOT?

[Quoted] Do you have the init ora paramers job_queue_processes and job_queue_interval [Quoted] set? The first tells Oracle how many jobs (including snapshot refresh) to run [Quoted] at a time. The second tells Oracle how often to run them.

[Quoted] If they're set to 0, Oracle won't be able to run jobs to refresh the [Quoted] snapshots. You'd have to do it manually (dbms_snapshot.refresh, or something like that.)

[Quoted] hth.

Yosi

Carlo Goldoni wrote:

> Hi, everybody.
>
> I created a snapshot to speed up query-operations on the DB.
> The problem is that the system does not refresh it!
>
> The statement I used to create the snapshot was like the following:
>
> CREATE SNAPSHOT SNAP_BR2_DEPT
> BUILD IMMEDIATE
> REFRESH FORCE
> START WITH SYSDATE + 5/1440
> NEXT SYSDATE + 5/1440
> AS SELECT * FROM BR2.DEPT
>
> If I'm not wrong, this statement should create a snapshot and have the
> system refresh it every 5 minutes. But this does not happen! Besides, if I
> execute a
>
> "SELECT * FROM ALL_SNAPSHOTS", the "LAST_REFRESH" field is either NULL or
> equals to "01/01/1950 12:00:00".
>
> Where is the mistake?
> Pleas, help!
>
> Thanks in advance, Carlo
> E-mail: cgoldoni_at_etnoteam.it
Received on Wed Nov 03 1999 - 15:33:21 CET