My Oracle Support Banner

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 to [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] /given_poid_type 0
2 PIN_FLD_ POID [0] /dummy -1 0

on PS4 with older dm_oracle executes select on sql table under field1, then one under field2, merges them and return result
on PS5 with new 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!

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