My Oracle Support Banner

Unable To Use Degree Of Parallelism (Doc ID 2894041.1)

Last updated on FEBRUARY 14, 2024

Applies to:

Oracle Insurance Accounting Analyzer - Version 8.0.6 and later
Information in this document applies to any platform.

Symptoms

Tried changing the DOP value in Application Configuration UI from 1 to 2 to execute IIA_CALCULATION batch to check the batch execution performance. The batch is failing with below error.

FSI_MESSAGE_LOG:

"LOG_NUM :: 22 ERR:: ORA-12801: error signaled in parallel query server P00A
ORA-22922: nonexistent LOB value"

LOG_NUM :: 10 ERR:: ORA-12839: cannot modify an object in parallel after modifying it

Cause

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
Symptoms
Cause
Solution


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