My Oracle Support Banner

Interface Move Transactions To Oracle Assets Poor Performance (Doc ID 1503587.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Installed Base - Version 12.1.3 and later
Information in this document applies to any platform.


csiviib.pls

Goal

Interface Move Transactions to Oracle Assets Poor Performance

The TKProf shows wait time for Util file I/O.
The concurrent process is trying to write to util file even though CSE and CSI debug are turned off.

Elapsed times include waiting on following events:
 Event waited on Times Max. Wait Total Waited
 ---------------------------------------- Waited ---------- ------------
 SQL*Net message to client 2 0.00 0.00
 SQL*Net message from client 2 0.00 0.00
 utl_file I/O 168 0.00 0.01
********************************************************************************
 

Solution

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
Goal
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.