PCM_OP_BILL_ITEM_ADJUSTEMENT Retrieves Huge No Of Events Causing A Dm_oracle Memory Issue (Doc ID 2571167.1)

Last updated on JULY 25, 2023

Applies to:

Symptoms

The  dm_malloc issue as results of PCM_OP_BILL_ITEM_ADJUSTEMENT are too big due to which High Water Mark warnings were seen in the log. it retrieves over 80000 events

 

The one single PCM_OP_SEARH is using up a large part of the dmo shared memory.This number of events could increase, especially for large accounts.
They cannot increase the dmo shared memory size forever. System memory is limited on a machine.

It is needed the OOB code to use STEP-SEARCH for that opcode, so it will not consume all the available memory for a single call.

Cause

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