Performance Decrease Of PCM_OP_READ_FLDS For Arrays With Sub-array
Last updated on SEPTEMBER 24, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 7.5.0]
Information in this document applies to any platform.
When executing READ_FLDS for object with array and subarray, dm_oracle makes excessive operations since deployment of PS5.
Executed read flds specifying fields as follows:
0 PIN_FLD_POID POID  0.0.0.1 /given_poid_type 0
0 TP_FLD_INV_GL2FEE ARRAY [*]
1 PIN_FLD_ ARRAY [*]
2 PIN_FLD_ POID  0.0.0.1 /dummy -1 0
on PS4 with older dm_oracle11g64.so dm_oracle executes select on sql table under field1, then one under field2, merges them and return result
on PS5 with new dm_oracle11g64.so dm_oracle executes exactly same select, but after finished merge, it executes same select times number of elements in table under field2.
For table with 1000 elements with 1000 elements thats performance loss of 1000 times since its same flow executed 1000 times instead of 1.
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