Materialize Views Time Taken To Refresh
Hi,
We have a few materialize views refresh in a program which is called by e-business concurrent program.
Here are the base create statement for the MV.
CREATE MATERIALIZED VIEW "APPS"."MVA"
BUILD IMMEDIATE
USING INDEX
REFRESH FORCE ON DEMAND
WITH ROWID USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE QUERY REWRITE
AS SELECT....
It is found that this concurrent program which is called to refresh these views will take 30min-1hr to refresh during normal peak hour. It takes 2-3 hr to refresh especially when cpu went up to 99%.
But during none peak hours it takes only 1 minutes to refresh.
Daily there are records inserted into the MV based tables.
We have a few materialize views refresh in a program which is called by e-business concurrent program.
Here are the base create statement for the MV.
CREATE MATERIALIZED VIEW "APPS"."MVA"
BUILD IMMEDIATE
USING INDEX
REFRESH FORCE ON DEMAND
WITH ROWID USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE QUERY REWRITE
AS SELECT....
It is found that this concurrent program which is called to refresh these views will take 30min-1hr to refresh during normal peak hour. It takes 2-3 hr to refresh especially when cpu went up to 99%.
But during none peak hours it takes only 1 minutes to refresh.
Daily there are records inserted into the MV based tables.
0