My Oracle Support Banner

Messages are queued up due slow in inserting into DB (Doc ID 1609595.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Java CAPS - Version 5.1.3 and later
Information in this document applies to any platform.

Symptoms

Project is slow in processing the messages into a DB,  the dba noted a select statement is running pre/post the update. But the JCAPS project does not call a select statement, but calls an insert and then the insertRow methods, inherent in the Eway.

The command insertRow() appears to be initiating a select command, the insert step runs reasonably quickly but the issuing of the select command doing a full table scan is what it causing the delay.

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.