Mview Refresh Slow Because of SELECT TO_NUMBER(VALUE) FROM V$SES_OPTIMIZER_ENV WHERE NAME = 'parallel_ddl_forced_degree'
(Doc ID 1484133.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Server - Enterprise Edition - Version 18.104.22.168 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|