Data Currencies for a View Grow Very Fast, Impacting LSH DB Users Login Process

(Doc ID 1996741.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Life Sciences Data Hub - Version and later
Information in this document applies to any platform.


On Oracle Life Sciences Data Hub (LSH) with the,,, and one-off patches applied,

Users are not able to login to database using the database accounts due to a logon trigger taking a long time time to execute.
Login to sqlplus/Toad/SQLDeveloper hangs.
The logon trigger is taking time to execute the queries in cdr_exe_environment.establishLogonContext.
This is happening after applying the LSH patch.
This is an intermittent but frequent issue, mostly after when a lot of jobs are executed.

Expect that the login to database using LSH DB accounts should be allowed within few seconds.

The issue can be reproduced with the following steps:
1. Attempt to login to LSH database with an LSH DB user.

The issue has the following business impact:
Due to this issue, users are not able to build the Informatica mappings which are required for study.


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