Changed the SequencePreallocationSize value from 50 to 1 but the change is not reflected at runtime
Last updated on JANUARY 04, 2017
Applies to:Oracle SOA Suite - Version 22.214.171.124.0 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 eis/DB/VLTD
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms