WHO-DD Coding Browser With C-Format Is Very Slow (Doc ID 2490815.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

The Who-DD Coding Browser when using C-Format Dictionary is very slow.

For example, if a user enters "Aspirin" as Product name, it takes more than 60 seconds for the Drug Coding screen to open.

Conversely, the SQL Statement, when executed directly while connected to the database as the Argus Safety schema owner, only takes less than 2 seconds to select about 5000 records e.g. :

Steps to Repeat:
The issue can be reproduced at will with the following steps.

1. Load WHO-DRUG format C (also applies to B) via the schema creation tool.
2. Log in to the application and open a case and go to the product tab and perform a search on 'Aspirin' via the WHO-DRUG browser.
 
Observe that there are over 1000 rows returned and it takes somewhere between 60-90 seconds to return the result set.

vs.
The SQL Statement when run independently via sql which takes only less than 2 seconds to select about 5000 records:

Changes

Cause

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