High and Low Volatility Oracle Table Parameters in CSA are not applied to all Clarity tables

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

In CSA – Database there is the below settings for Oracle: High-Volatility Table Parameters and Low-Volatility Table Parameters  and they are not getting applied to newly created Oracle tables

highVolatilityParameters="PCTFREE 20 PCTUSED 60" lowVolatilityParameters="PCTFREE 5 PCTUSED 80"

Environment

Clarity 16.x.

Cause

Reviewed as DE167463, Working as designed

Resolution

Working as designed.

• The volatility parameters in the properties.xml file are applied when Clarity creates certain tables on a fresh deployment.
• Custom object tables are not updated based on CSA settings.
• There is also a config file that is used in very specific circumstances.
• Overall, Clarity database tables are not expected to exactly match what is set in the CSA, and even new tables are set in according to the database configuration.

Request DBA to manually manage volatility settings for the required tables in Oracle. Avoid updating the setting in CSA. We recommend manual configuration by DBA