OVD DB Adapter SQL Query Generated is Slow (Doc ID 1951464.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Virtual Directory - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Goal

Oracle Virtual Directory (OVD) 11g.

Already reviewed the documentation and known issues for Database (DB) adapters, but still experiencing performance issues.

For example, an OVD DB adapter is using two views with several mapped attributes of users.  For any login through OVD, the following problematic query is seen on the DB:

SELECT DISTINCT PROD_OIM.OVD_USER_GROUPS_VIEW.NAME,PROD_OIM.OVD_USER_GROUPS_VIEW.GUID FROM PROD_OIM.OVD_USER_GROUPS_VIEW WHERE
(UPPER(PROD_OIM.OVD_USER_GROUPS_VIEW.LOGIN) = UPPER( :1 )) OR
(UPPER(PROD_OIM.OVD_USER_GROUPS_VIEW.LOGIN) = UPPER( :2 )) OR
(UPPER(PROD_OIM.OVD_USER_GROUPS_VIEW.LOGIN) = UPPER( :3 )) OR
(UPPER(PROD_OIM.OVD_USER_GROUPS_VIEW.LOGIN) = UPPER( :4 )) OR
(UPPER(PROD_OIM.OVD_USER_GROUPS_VIEW.LOGIN) = UPPER( :5 )) OR
(UPPER(PROD_OIM.OVD_USER_GROUPS_VIEW.LOGIN) = UPPER( :6 )) OR
(UPPER(PROD_OIM.OVD_USER_GROUPS_VIEW.LOGIN) = UPPER( :7 )) ORDER
BY PROD_OIM.OVD_USER_GROUPS_VIEW.NAME

This query takes a long time to perform.

Seems OVD does not know which attribute is responsible for holding the username, thus this problematic query.

Why is this query not constructed where the username is just one single attribute, not the several ones mapped?  Can this query can be changed or tuned?
 

Solution

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