cancel
Showing results for 
Search instead for 
Did you mean: 

Sessions opening\closing in oracle while fetching data from XI

Former Member
0 Kudos

Hi Friends,

I used JDBC adaptor to fetch data from Oracle. I set the poll interval 86400 seconds because we need to run it on daily basis.

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Did u try this paramter in JDBC sender adapter...

Disconnect from Database After Processing Each Message

Set this indicator if the database connection is to be released and reestablished before every poll interval.

-Siva Maranani

Answers (0)