Re: HELP! HOW TO REFRESH A SNAPSHOT?

Yosi, you're great!

I must admit that job_queue_processes was 0! Now I set it to 10 and everything works fine!

Thanks again, Carlo

In article <382047B1.6FBB034F_at_compuserve.com>,   Yosi Greenfield <ygreenfield_at_compuserve.com> wrote:
> Do you have the init ora paramers
job_queue_processes and job_queue_interval
> set? The first tells Oracle how many jobs
(including snapshot refresh) to run
> at a time. The second tells Oracle how often to
run them.
>
> If they're set to 0, Oracle won't be able to run
jobs to refresh the
> snapshots. You'd have to do it manually
(dbms_snapshot.refresh, or something
> like that.)
>
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 05 1999 - 12:11:03 CET