My Oracle Support Banner

Poor Performance Due To Database Setting: _optimizer_dsdir_usage_control (Doc ID 2368567.1)

Last updated on MARCH 02, 2018

Applies to:

Oracle Argus Safety - Version 8.0.1 and later
Information in this document applies to any platform.

Symptoms

The system performance is very slow for both Argus user interface (tab switching) and AG Services processes
It takes
-Case import- 6 minutes
-E2B validation - 6 minutes
-E2B check- 6 minutes
-Auto schedule - 15-20 minutes


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
References


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