Poor Performance of GLPAUTOP Program - Automatic Posting Program (Doc ID 1600340.1)

Last updated on AUGUST 26, 2020

Applies to:

Symptoms

There is performance issue in Automatic Posting program. Autopost program search many times for batches with a criteria provided and each search is taking time.
This following select statement is executed many times for different criteria provided.

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.05 0.02 0 0 0 0
Execute 1 14.77 147.64 162442 163531 21 0
Fetch 1 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 14.82 147.66 162442 163531 21 0

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.