6 Tuning Performance

Tuning Spark and Kubernetes Configuration

This chapter provides fine tuning considerations for OIRI.

The following table lists the parameters for fine tuning Spark and Kubernetes configuration and the specific values for small, medium, and large scale implementations.

Parameter	Description	Small Scale	Medium Scale	Large Scale
executorInstances	Specify the number of executor pods.	3	5	7
driverRequestCores	Specify the CPU request for the driver pod.	2	3	4
driverLimitCores	Specify the hard CPU limit of the driver pod.	2	3	4
executorRequestCore	Specify the CPU request for each executor pod.	2	3	4
executorLimitCore	Specify the hard CPU limit of each executor pod.	2	3	4
driverMemory	Specify the hard memory limit of the driver pod.	2g	3g	4g
executorMemory	Specify the hard memory limit of each executor pod.	2g	3g	4g

Tuning Entities Configuration

When the source of data import is flat files, then specify the following parameter values:

• lowerBound: The lowest value of the EXTERNAL_ENTITY_ID
• upperBound: The largest value of the EXTERNAL_ENTITY_ID
• numPartitions: Specify 3 for small scale, 5 for medium scale, and 7 for large scale

Here, the value of the EXTERNAL_ENTITY_ID for various entities are as follows:

• Users: EXT_USER_ID

• Applications: EXT_APP_ID

• Entitlements: EXT_ENT_ID

• Accounts: EXT_ACCOUNT_ID

• Assigned Entitlements: EXT_USER_ID

• Roles: EXT_ROLE_ID

• Role User Memberships: EXT_ROLE_ID

• Role Entitlement Composition: EXT_ROLE_ID

When the source of the data import is Oracle Identity Governance database, specify the following parameter values:

• lowerBound: 0
• upperBound: Total number of rows in the entity OIG table
• numPartitions: 3 for small scale, 5 for medium scale, 7 for large scale

The OIG tables for various entities and the SQL queries to get the number of rows are as follows:

• Users:

  select count (*) from usr;

• Applications:

  select count (*) from app_instance;

• Entitlements:

  select count (*) from ent_list;

• Accounts:

  select count (*) from orc;

• Assigned Entitlements:

  select count (*) from ent_assign;

• Roles:

  select count (*) from ugp;

• Role User Memberships:

  select count (*) from usg;

• Role Entitlement Composition:

  select count (*) from poc;