Queries Related to Item Ticket Printing are Taking a Long Time and Using a Lot of CPU on Database (Doc ID 2122246.1)

Last updated on APRIL 03, 2016

Applies to:

Oracle Retail Store Inventory Management - Version 14.1 and later
Information in this document applies to any platform.

Goal

In the Store Inventory Management (SIM) application, we find that the queries related to item ticket printing are taking a long time and using a lot of CPU on the database.  This can be observed by generating AWR reports while item tickets are printed.
 

Solution

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 hundreds of Community platforms