Mview Refresh Slow Because of SELECT TO_NUMBER(VALUE) FROM V$SES_OPTIMIZER_ENV WHERE NAME = 'parallel_ddl_forced_degree'
Last updated on AUGUST 23, 2012
Applies to:Oracle Server - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
A single mview job refreshes 764 mviews to 50 different databases. In 10g this took about 60 minutes; in 11gR2 this is taking about 90 minutes. A tkprof showed the total elapsed time is 84 minutes, out of which the below statement is taking over half of that:
Upgrade to 11gR2.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms