OBIA 11g: Process To Reduce The Parallel Degree To Limit The Creation of Sessions On The Database At Scenario Level (Doc ID 2402327.1)

Last updated on AUGUST 05, 2021

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Goal

Scenario: Table maintenance procs after loading the Fact tables for creating of indexes are running in parallel and creating many sessions on the database, which is blocking other sessions on the database to open.

Question: How to reduce this Parallel degree to a limit at the scenario level?

Environment Details: OBIA 11.1.1.8.1

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

References

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

OBIA 11g: Process To Reduce The Parallel Degree To Limit The Creation of Sessions On The Database At Scenario Level (Doc ID 2402327.1)

Applies to:

Goal

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!