Need Parallel Hints For DML And DDL Statements In Patches And Service Packs

(Doc ID 2356640.1)

Last updated on FEBRUARY 13, 2018

Applies to:

Oracle Utilities Meter Data Management - Version 2.2.0.1.0 and later
Oracle Utilities Framework - Version 4.3.0.4.0 and later
Information in this document applies to any platform.

Goal

When upgrading to MDM v2.2 SP1 (FW 4.3 SP4) is it possible to create parallel hints for DML and DDL statements for Service Packs and Single Fix Patches?

This would reduce time for for DML and DDL statements that involve large tables like D1_INIT_MSRMT_DATA and D1_MSRMT.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms