Skip to main content

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.