Sessions opening\closing in oracle while fetching data from XI

[Former Member]

Hi Friends,

Now when XI fetch data from Oracle, It will open session in oracle, but it is not closed automatically. So, I have nearly 100 channels, and all channels are activated. So, for each channel 1 session is opened in oracle. By this way, the oracle server performance goes down. It is not working properly at that time.

How can I close these sessions in oracle.

Regards,

Narendra

[rajasekhar_reddy14 · Accepted solution]

Hi Narendra,

Why dont you select the option in Define Aditional Parameters in select Disconnect from Database After Processing Each Message.

When you select this option it close the coneection after operation.

Regards,

Raj