What should the database sequences caching size should be? We seen that some areas are set to nocache (0) and others are set to 20.
Name: BUSINESS_OPPORTUNITY_NO_SEQ
Cache Size: 0
Name: RISK_ASSESSMENT_SEQ
Cache Size: 20
With the cache size on RISK_ASSESSMENT_SEQ set to ‘20’ we lose 20 Risk Assessment numbers every time the DB shutdown.
Risk Assessment cache size set to 20 rather than 0
This topic has been closed for comments
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.