Inactive Session in ODI Repository

SukantaBarari-Oracle

Hello,

We have developed 10 mappings. All of these mappings are one to one mapping. They are no expression or conversion. The data is in CSV file (i.e. source system) and target is oracle ADW (i.e. target system). We have create a simple load plan to trigger all the mapping in parallel mode to load the data.

Before start the load plan we have observed no of inactive session for ODI repository is 4. After trigger the load plan the no of inactive session increased to 30. Once the load plan successfully completed out of the 30 inactive session only 12 got closed , remaining 18 inactive session are still in inactive mode. Those are not closed at all.

The no of inactive session are getting increase every time we trigger the data load process,

Any idea on this issue.

ODI Version is ODI Market place V12.2.1.4.210321.

Thank you all in advance.

Adrian_Popescu-Oracle

Hi,

Apply Patch 32708064: Inactive ODI sessions not releasing DB connections

Adrian

 

Adrian_Popescu-Oracle

Hi,

Apply Patch 32708064: Inactive ODI sessions not releasing DB connections

Adrian

 

User_51600

Hi Adrian

we have an issue in our ODI similar to above, we are seeing 1000s of sessions just lingering in the database on an idle wait event

SQL> col event format a30

SQL> col state format a30

SQL> /

EVENT                         STATE                           COUNT(*)

------------------------------ ------------------------------ ----------

SQL*Net message from client   WAITING                             1943

SQL*Net message from client   WAITED KNOWN TIME                     72

Do you think this patch will help us as well ?

we are on 12.2.1.4

Adrian_Popescu-Oracle

Hi,

If the idle sessions refer to ODI, apply the patch.

Adrian

User_51600

Hi Adrian

Thank You very much for your reply.

We found that the patch is already applied in our production environment.

regards