My Oracle Support Banner

Database Parameters (Parallel Threads) In ECM (Doc ID 3074700.1)

Last updated on MARCH 06, 2025

Applies to:

Oracle Financial Services Enterprise Case Management - Version 8.0.7 and later
Information in this document applies to any platform.

Goal

Parallel Threads on Mantas ECM

V_MERGE_HINT in select * FROM ATOMICEC.FCC_DM_DEFINITION.

It is saying PARALLEL(T) PARALLEL(S).

How can we control the number of parallel threads it uses.

Where is this configuration saved.

After the DB upgrade to 19c we are facing some of the queries taking a lot of parallel threads. This causes the DB to queue up the queries.
 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.