CSITXIMW CONCURRENT REQUEST NOT CLEARING SESSIONS IN THE DB AND IN ICX_SESSIONS (Doc ID 1555057.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Installed Base - Version 12.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 12-06-2014***

Symptoms

in 12.0.4 and 12.0.6 when running the Concurrent program IB TRANSACTION LINES IMPORT, which spawns CSITXIMW (IB TRANSACTION LINES IMPORT Worker) is creating many entries in icx_sessions, many times per session and lasting less than a second:

The program is run with these parames:
Nr of workers: 3
Purge Processed Rows: Yes

Expected Behavior

Much less entries should be created in icx_sessions

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Run Concurrent program IB TRANSACTION LINES IMPORT
2. Check entries created in icx_sessions table

Business Impact
Due to this issue, System Administrator can not properly size the Wentier (oc4j process)

Cause

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