My Oracle Support Banner

Performance: EGO Spreadsheet Java Concurrent Program uses Literals instead of Bind Variables and Fragments the Shared Pool (Doc ID 954706.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Product Hub - Version 11.5.10.2 and later
Information in this document applies to any platform.
INVVITMB.pls, EGOIBLKB.pls, EGOIJAVA, EGO Spreadsheet Java Concurrent Program


Symptoms

It was observed that the PLM Item Excel Upload program was using literals for few queries, which are executed very frequently. This can cause fragmentation of the shared pool as the queries are swapped in and out of the shared pool very frequently. The higher the number of items uploaded, the greater would be the degradation in performance.

-- Steps To Reproduce:
1. Run the PLM Item Excel Upload to create / update items with trace enabled
2. Observe that the queries like the below appear once for every record uploaded from excel.

This happens only if the queries use literals and is not expected, as the shared pool is not utilized efficiently.

Cause

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
Symptoms
Cause
Solution
References

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