Identity Management (MOSC)

MOSC Banner

OIM SCIM calls taking long time to respond on ~150k user base.

edited Oct 16, 2017 5:02AM in Identity Management (MOSC) 1 commentAnswered

Hi,

We have OIM 11g server deployed over Weblogic (10.3.6) and configured with Oracle 11g Database.

We have a user base of around 150k Users.

All new users in OIM are created/registered/Updated/Lock/Unlock via OOTB SCIM calls only.

With our current setup, SCIM calls are taking too long to respond. i.e. for a simple create user, it is taking almost 40 seconds to complete the SCIM request.

Though, creating user directly from OIM admin console (via xelsysadm user) is creating user immediately and there is no delay.

From oim-diaganostic logs (below excerpt), we have observed one query is taking considerable high time to execute (almost 35-37 seconds) on 150K users.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center