Performance Issue with GLSTPM Incremental Add/Delete Summary Template Program When There Are a Large Number of Summary Accounts
(Doc ID 1682949.1)
Last updated on OCTOBER 04, 2018
Applies to:Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Executable:GLSTPM - Add/Delete Summary Accounts
Performance issue reported in Incremental Add/Delete Summary template program (GLSTPM):
slow running sql statement as found in the trace is:
DELETE FROM GL_BALANCES
WHERE template_id+0 = :h_template_id
AND code_combination_id BETWEEN
:curr_min_ccid AND :curr_max_ccid
AND rownum <= :row_num
No custom indexes on gl_balances are in place
Have run the gather schema stats program for apps and gl schemas and issue remains.
Log file shows slowness in (as an example):
>> glstind() 05-AUG-2013 16:09:36
SHRD0119: Deleted 20000 record(s) from GL_BALANCES.
<< glstind() 08-AUG-2013 05:17:37
A large number of summary accounts are created from each summary template.
Ranging from several hundred thousand to over a million summary accounts per template.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document