Performance Decrease Of PCM_OP_READ_FLDS For Arrays With Sub-array (Doc ID 1610644.1)

Last updated on MARCH 23, 2019

Applies to:

Symptoms

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.0.1 /given_poid_type 0
0 TP_FLD_INV_GL2FEE ARRAY [*]
1 PIN_FLD_ ARRAY [*]
2 PIN_FLD_ POID [0] 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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.