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

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