Performance Decrease Of PCM_OP_READ_FLDS For Arrays With Sub-array
(Doc ID 1610644.1)
Last updated on AUGUST 03, 2018
Applies to:Oracle Communications Billing and Revenue Management - Version 188.8.131.52.0 to 184.108.40.206.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!