As an Oracle E-Business Suite (EBS) Applications DBA (Apps DBA), there are maintenance tasks that you should perform on a regular basis to ensure the overall health and performance of your EBS environment. General guidance for this activity is described in the Oracle E-Business Suite 12.2 Maintenance Guide.
A critical maintenance task that you should perform is checking and managing the health of your EBS sequences. Many EBS customers have been running in production for many years – some for decades. As a result, sequences in your EBS database may be nearing their maximum value.
We are pleased to announce the publication of a new My Oracle Support (MOS) knowledge document and patch that includes sequence check scripts to assist EBS Apps DBAs with EBS 12.2 sequence management:
- Managing Sequences in Oracle E-Business Suite Release 12.2 (MOS Note 2989870.1)
- Patch 36119960
What is an Oracle Database Sequence?
A sequence is an Oracle database object from which multiple users can generate unique integers. For more information, see CREATE SEQUENCE, Oracle Database SQL Language Reference and Managing Sequences, Oracle Database Administrator’s Guide.
EBS uses sequences to automatically generate primary key values.
How Frequently Should You Check Your EBS Database Sequences?
Here are the guidelines for when to check your sequences:
-
Start today: Review, plan, and perform the recommendations documented in in Managing Sequences in Oracle E-Business Suite Release 12.2 (MOS Note 2989870.1).
-
Perform a check at least once a quarter or more frequently if your environment has a large number of transactions: Follow the recommendations documented in Managing Sequences in Oracle E-Business Suite Release 12.2 (MOS Note 2989870.1).
-
Do this as soon as possible: Subscribe to receive automatic updates to Managing Sequences in Oracle E-Business Suite Release 12.2 (MOS Note 2989870.1) and review the latest documented guidelines at the time of publication.
How do You Proactively Manage Your EBS Sequences?
To proactively manage your EBS sequences, you should do the following:
-
Review all product-specific sequence management documentation and apply all sequence management patches provided for the products used in your instance to obtain the latest updates. See “Section 2: Apply Product-Specific Patches” in Managing Sequences in Oracle E-Business Suite Release 12.2 (MOS Note 2989870.1).
-
Use the diagnostic scripts provided by Oracle E-Business Suite to check the status of sequences in your environment and perform recommended actions. See “Section 3: Monitor Sequence Status” in Managing Sequences in Oracle E-Business Suite Release 12.2 (MOS Note 2989870.1).
-
Review the recommended guidance for cycling sequences in “Section 4: Manage Cycling Sequences” in Managing Sequences in Oracle E-Business Suite Release 12.2 (MOS Note 2989870.1).
References
- Managing Sequences in Oracle E-Business Suite Release 12.2 (MOS Note 2989870.1)
- Oracle E-Business Suite 12.2 Maintenance Guide.