Oracle DB Block size

Products

• CA Identity Manager

Issue/Introduction

The Archive database tables are reaching the 32TB limit of 8k block sizes. 

Can the Identity Suite software use 16k and 32k block size tablespaces? 

Environment

Identity Manager and other suite components. 

Resolution

The only limit we on the Block Size in Oracle is in regards to the Report Schema, which requires 8k block size:
https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-manager/14-5/installing/installation-prerequisites/central-databases.html

 

Otherwise there are no limitations on the block size from a product standpoint.   

Please be aware, even 32gb of data is going to be hard for the components to consume and utilize in an effective manner, the recommended method to address reaching that 32gb limit would be to cleanup the archived database, or alternatively backup that table in case it is needed and create an empty set of archive tables.