My Oracle Support Banner

Changed the SequencePreallocationSize value from 50 to 1 but the change is not reflected at runtime (Doc ID 2007190.1)

Last updated on APRIL 23, 2019

Applies to:

Oracle SOA Suite - Version and later
Information in this document applies to any platform.


In the DB Adapter configuration the javax.resource.cci.ConnectionFactory connection group has a parameter for sequencePreallocationSize which is set to 50. This value was changed to 1 but has not altered the behavior at runtime.

These are the steps followed:
Login to Uat soa console:
Click on “Lock and edit”.
Click on “Deployments” --> “DbAdapter”
Click on “Configuration” --> “Outbound Connection pools”
Click on “+” and click on <JNDI NAME>

In the outbound connection properties table , Double click on “SequencePreAllocatioonSize”  “property value “ column where it is set to 50.

Set it to “1” and hit enter [The change doesn’t happen otherwise] and Save.
Go back to “Deployments” select “DbAdapter” and click “Update”  
Click “Finish” in the next screen .

Activate the changes
No restart is required


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.