Object12_5 performance in Oracle RAC using SECUREFILE

book

Article ID: 36212

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal CA Risk Analytics CA Secure Cloud SaaS - Arcot A-OK (WebFort) CLOUDMINDER ADVANCED AUTHENTICATION CA Secure Cloud SaaS - Advanced Authentication CA Secure Cloud SaaS - Identity Management CA Secure Cloud SaaS - Single Sign On

Issue/Introduction

Question:

We are seeing performance slowness and contention with the object12_5 table in Oracle RAC. Can we change the table to use SECUREFILE instead of basic LOB?

 

Answer:

Yes, as SECURFILE is a recommended by Oracle as a performance improvement it is supported by CA Identity Manager. 

Conversion to SECUREFILE requires dropping and rebuilding the table. Please contact your Oracle DBA for assistance.

 

 

 

Environment

Release: CAIDMB99000-12.6.7-Identity Manager-B to B
Component: