Proposal To Change Poid_type From Strings To Numbers
Last updated on JUNE 21, 2017
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.
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