Hi,

Whenever there is a lot of traffic, We are getting problem database of TN.
Our Oracle Database experts trace and found that - After all SQL commands (including Select), TN sends COMMIT. So, it slowdowns performance.

Any idea about this issue? Can we turn OFF auto commit (without loosing data ) ?

Please let me know if you need any other details.
I appreciate your response.

Thanks,
-Mehul Raol