|Applies To||RSA Product Set: Identity Governance and Lifecycle|
RSA Version/Condition: 7.0.2
|Issue||While performing bulk data collection or provisioning, a significant drop in performance is observed. For example, instead of taking minutes, provisioning takes tens of minutes or hours, and then the following error is reported and then bulk provisioning fails:|
While the <object name> reported in the ORA-01654 error can be either an AVUSER table or index, the <tablespace name> should be one of the following standard AVUSER Tablespace names.
|Cause||The primary reason for poor performance followed by the ORA-01654 error is that the datafiles for the AVUSER tablespaces were undersized.|
The ORA-01654: unable to extend ... error indicates that the datafile has been growing until it ran out of space. Extending a datafile is an I/O intensive operation, and this would affect the performance of any database operation that adds data to the database.
A secondary issue may be that the physical disk or ASM disk group has run out of space.
The following explanation is taken from the Oracle Support Note 146595.1 - Overview Of ORA-01654: Unable To Extend Index %s.%s By %s In Tablespace %s (To access this note in full, an Oracle Support login is required):
This error does not necessarily indicate whether or not you have enough space in the tablespace, it merely indicates that Oracle could not find a large enough area of free contiguous space in which to fit the next extent.
|Resolution||To solve this issue, the Oracle database needs to be modified, where this is typically performed by an Oracle DBA.|
The following solutions are taken from the Oracle Support Note 146595.1 - Overview Of ORA-01654: Unable To Extend Index %s.%s By %s In Tablespace %s (To access this note in full, an Oracle Support login is required):
The extents must be adjacent to each other for this to work.
The following SQL statements may also assist when diagnosing Tablespace space issues.
Notes on resizing
The actual amount to add or resize the datafile depends on data volumes. As data volumes vary from customer to customer, a specific recommendation cannot be provided. So, in general, try increasing the existing datafile size by 50% to 100%.
However, a Aveksa Statistics Report (ASR) can be generated to determine existing data volumes.