Page 1 of 1

Every close Connection pool call rollback

Posted: Tue 03 Oct 2017 09:28
by BobreshovR
Hi!
We created statistics from our oracleDB http://www.dba-oracle.com/m_user_rollbacks.htm.
And DevArt oracle provider create 75% rollback.
dbMonitor show that every close connection pool call rollback.
We found this topic about it viewtopic.php?f=1&t=24015&hilit=rollback
And we can't disable pooling, because we have highload system.
How can we disable rollback after commits ans select query?

Thanks

Re: Every close Connection pool call rollback

Posted: Wed 04 Oct 2017 16:47
by Shalex
At the moment there is no possibility to disable rolling back of all pending operations on a connection before returning the connection to pool. We will investigate the possibility of implementing this functionality, but we can't tell any timeframe at the moment. We will inform you when any results are available.