Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need help with snapshot refreshing.
On Sun, 04 Jun 2000 07:00:12 GMT, nitefrog_at_yahoo.com (The NiteFrog.-) wrote:
>Hello All,
>
>I am completely stumped, I cannot get the database to refresh. The
>snapshot created but will not refresh! Here is the snytax I used:
>
>create snapshot log on icdb.CHCS_DIVISION
> tablespace USER_REFRESH
> storage(initial 10K next 10K pctincrease 0);
>
>create snapshot LOCAL_CHCS_DIVISION
> pctfree 5
> tablespace USER_REFRESH
> storage (initial 100k next 100k pctincrease 0)
> refresh fast
> start with SysDate
> next sysdate + 1/(60*24)
> as select * from icdb.CHCS_DIVISION;
>
>commit;
>
>I want to to refresh every minute but it just wont work. Any help
>it greatly appreciated.
>
>Thank you,
>
>Kev.-
>
>email: kev_at_nospam.kconcept.com
>
>**** Remove the nospam. to email.
>***
Question did you make sure
job_queue_processes = <nonzero>
job_queue_interval = 60
in init<sid>.ora
IMO a refresh of every minute is *too* frequent and you are going to incur too much overhead.
Hth,
Sybrand Bakker, Oracle DBA Received on Mon Jun 05 2000 - 00:00:00 CDT