My Oracle Support Banner

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

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
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.