Proposal To Change Poid_type From Strings To Numbers
(Doc ID 1091291.1)
Last updated on MARCH 21, 2019
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Goal is to change poid_type from strings to numbers to save about 30% of the entire size of BRM database.
At present, Poid Types are strings stored in many tables. There are in total 4000 different object types, which could be stored as a unique ID and the % of space which can be saved is even higher for big tables such as EVENT_T (27%), ITEM_T (41%), PURCHASED_PRODUCT_T (32%) etc
All object types should not be stored as strings but be referenced with number.
All object types are really long strings.
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