Tuning Database
Since OIM has
heavily depends on database, obviously we need to tune the database for better
performance. Every time a user is created or provisioned resource to user,
there are dozens of operations taking places behind the scenes especially
tables of the functional databases.
Below table show
recommended initial setting for 4 CPU (64 bit) and 8/20 GB RAM:
Parameters
|
Initial
setting for DB
|
db_block_size
|
8192
|
memory_target
|
Minimum
value is 6 GB.
Maximum is MEMORY_TARGET/MEMORY_MAX_TARGET=Total Memory X 80% or 20GB, whichever is greate |
sga_target
|
Minimum
value is 4 GB.
Maximum is SGA_TARGET=Total Memory X 80% X 60% or 16 GB assuming an overall memory cap of 20 GB for the Oracle Identity Manager database to run. |
pga_aggregate_target
|
Minimum
value is 2 GB. Maximum is
PGA_TARGET=Total Memory X 80% X 40% or 4 GB whichever is greater |
sga_max_size
|
10 GB
|
db_keep_cache_size
|
800M
|
log_buffer
|
15 MB
|
cursor_sharing
|
FORCE
|
open_cursors
|
2000
|
session_cached_cursors
|
800
|
query_rewrite_integrity
|
TRUSTED
|
db_file_multiblock_read_count
|
16
|
db_writer_processes
|
2
|
processes
|
Based on
connection pool settings
|
While
it is always recommended to check the Oracle Database Tuning reports within the
database, Oracle provides recommendations of which can be found at this
location: http://docs.oracle.com/cd/E14571_01/doc.1111/e14308/tuningfordb.htm#OMADM1811
Tuning Application Server
- OIM uses oimOperationsDB and oimJMSStoreDS datasource deployed on WebLogic server. By default, maximum connection size is set to 50. You can increase size as per your environment. Note: Make sure the same connection size should be set to in DB side too.
- Number of Message Driven Bean (MDB):OIM uses OIMMDBWorkManager MDB for processing all offline operations such as recon, audit, orchestration, etc. By default, it set to 80. You can set to -1 for unlimited.
- Disable Reloading of Adapters and Plug-in Configuration
- Change default memory arguments.
Periodically
purging the Orchestration, Requests, Audit, Reconciliation tables in OIM.