Questions About the Capacity of POID_ID0 Column
(Doc ID 1078238.1)
Last updated on SEPTEMBER 12, 2019
Applies to:
Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and laterInformation in this document applies to any platform.
Purpose
On Oracle Communications Network Charging and Control (BRM), given the following scenario:
- Suppose the current POID_ID0 value is extremely large in a production system, for example: 47,137,786,786 (11 digits)
- Analysis shows that this value is increasing by an average of 2,161,616,813 per month.
The latter point may be due to a combination of number of Call Data Records (CDRs)/events combined with an operational issue where the increment for dm_oracle and for the Rated Event Loader (REL) have been raised to overcome contention on allocating next sequence numbers from the single sequence.
Questions and Answers
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
| Purpose |
| Questions and Answers |
| What is the largest value that the POID can handle (in the context of non-partitioned tables initially). |
| We need to ensure that the system will have plenty of capacity in the coming years, and will not suffer from some kind of overflow in the long term. |
| Is there any follow-on implication on the capacity to hold partitioned POIDs. |