Refresh materialized view each second ?
641018Apr 16 2009 — edited Apr 16 2009Hello all,
I would like to refresh my materalized view each second. The creation is success with the following code, but when I monitor the table user_jobs, I see that the next scheduling is correctly planned (previous time + 1 second), but each time the view is refresh, it seems that the job is re-executed each 5 seconds.
Do you know if this behaviour is possible ?
Best Regards
Sylvain
CREATE MATERIALIZED VIEW test
BUILD IMMEDIATE
REFRESH FAST
START WITH SYSDATE NEXT SYSDATE + 1/24/60/60
AS SELECT ....