Order IDs not getting generated in sequence using RAC database
Hi, If RAC database is used for one of the products, where weblogic talks to RAC database using different data sources, orders are not getting generated in sequence. Is there a way to address it?
Database Partitioning and Order IDs
Each database instance can allocate unique IDs to new orders. OSM allocates a block of unique order IDs for each database instance (for both single instance and Oracle RAC databases). The block size equals the partition size. When a block of order IDs is
exhausted, the next block is allocated. If the corresponding partition does not exist,OSM will attempt to create it automatically. Range partitioning works best if the partition size is larger than 50,000 orders.
Database Partitioning and Order IDs
Each database instance can allocate unique IDs to new orders. OSM allocates a block of unique order IDs for each database instance (for both single instance and Oracle RAC databases). The block size equals the partition size. When a block of order IDs is
exhausted, the next block is allocated. If the corresponding partition does not exist,OSM will attempt to create it automatically. Range partitioning works best if the partition size is larger than 50,000 orders.
0