Performance Optimization of SAP GRC Access Control 5.3 - Apply Database Specific SAP Notes

Depending on your database apply the following SAP notes:

Database Note Number Title

MS SQL Server 1158625 Bad performance caused by Integer literals

MaxDB 927882 FAQ: MaxDB Update Statistics

Oracle 10G 1044174 Recommendation for CC 5.x running on Oracle 10G Database

Oracle 10G 830576 Parameter recommendations for Oracle 10g

Oracle 8.x/9.x 124361 Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x)

Oracle 9.x 823906 Oracle 9 database parameters tuning - EP in NW

All Databases 1178370 Risk Analysis and Remediation - Table sizes

Tip

If a batch risk analysis in Risk Analysis and Remediation doesn’t complete after a long run time, before aborting check your database. In some databases you need to activate auto-extension of the database manually. During a synchronization or batch risk analysis

temporary tables are filled and may hit your capacity limit.