OIM性能调优

Question

我们通过Weblogic部署了OIM 11g服务器，并配置了Oracle 11g数据库。我们有大约15万用户的庞大用户群。我们有作为OIM-SCIM客户端的前端应用程序。只要有新用户注册，客户端就会使用专用管理员凭证调用OIM-SCIM Create user call。Create User调用响应时间太长(约40秒)。

我们已经在适用的USR表上创建了索引，但仍然无法从日志中获得良好的性能，很明显，OIM在插入用户之前检索所有用户

对于如何提高OIM-SCIM性能有什么建议吗？

oim-诊断日志

    [2017-09-26T08:22:55.306+05:30] [oim_server1] [NOTIFICATION] [] [oracle.iam.identity.usermgmt.impl] [tid: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 5e09005b7f67b5f4:-3946d497:15eb9006a07:-8000-000000000002121a,0] [APP: oim#11.1.2.0.0] [DSID: 0000Luw6W2F3z04_vTL6iX1PmFNT00000H]  NOPAGING:: Search Criteria: arg1 = (arg1 = (Status) NOT_EQUAL arg2 = (Deleted)) AND arg2 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (arg1 = (usr_key) IN arg2 = ([1, 153, 169, 178, 179, 180, 185, 209, 218, 220, 225, 231, 236, 254, 260, 268, 274, 282, 290, 292, 441, 443, 455, 472, 473, 474, 487, 503, 518, 528, 534, 538, 543, 549, 556, 560, 563, 567, 568, 573, 583, 587, 588, 601, 602, 610, 611, 613, 616, 627, 630, 631, 632, 635, 649, 669, 679, 702, 298, 301, 302, 305, 318, 324, 329, 331, 340, 343, 353, 357, 367, 373, 386, and many more.... 8499, 18508, 18517, 18523, 18535, 18547, 18561, 18563, 18571, 18577, 18579, 18614, 18663, 18671, 18687, 18699, 18709, 18710, 18731, 18745]))) OR arg2 = (arg1 = (usr_key) IN arg2 = ([18782, 18788, 18807, 19932, 19935, 19943, 19960, 19964]))) AND arg2 = (arg1 = (usr_key) EQUAL arg2 = (*)))
[2017-09-26T08:22:55.308+05:30] [oim_server1] [NOTIFICATION] [] [oracle.iam.identity.usermgmt.impl] [tid: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 5e09005b7f67b5f4:-3946d497:15eb9006a07:-8000-000000000002121a,0] [APP: oim#11.1.2.0.0] [DSID: 0000Luw6W2F3z04_vTL6iX1PmFNT00000H]  NOPAGING:: PAGING_LIMIT system property = 500
[2017-09-26T08:22:55.308+05:30] [oim_server1] [NOTIFICATION] [] [oracle.iam.identity.usermgmt.impl] [tid: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 5e09005b7f67b5f4:-3946d497:15eb9006a07:-8000-000000000002121a,0] [APP: oim#11.1.2.0.0] [DSID: 0000Luw6W2F3z04_vTL6iX1PmFNT00000H] Searching for users with the specified criteria.
[2017-09-26T08:23:44.472+05:30] [oim_server1] [NOTIFICATION] [] [oracle.iam.configservice.impl] [tid: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 5e09005b7f67b5f4:-3946d497:15eb9006a07:-8000-000000000002121a,0] [APP: oim#11.1.2.0.0] [DSID: 0000Luw6W2F3z04_vTL6iX1PmFNT00000H] oracle.iam.configservice.internal.impl.ConfigManagerInternalImpl getAttributeusr_key
[2017-09-26T08:23:44.473+05:30] [oim_server1] [NOTIFICATION] [] [oracle.iam.configservice.impl] [tid: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 5e09005b7f67b5f4:-3946d497:15eb9006a07:-8000-000000000002121a,0] [APP: oim#11.1.2.0.0] [DSID: 0000Luw6W2F3z04_vTL6iX1PmFNT00000H] oracle.iam.configservice.internal.impl.ConfigManagerInternalImpl getAttributeExiting

Answer 1

我认为有一个来自Oracle的性能调优guide，您可能需要先检查一下。

它可能需要很长时间才能完成，原因有很多。首先检查通过OIM UI创建用户是否有任何不同，如果花费的时间相同，并且指南中的所有内容都进行了调整，接下来我会检查附加到用户创建过程的处理程序。它们可能需要一段时间才能完成。