Transaction Control with TN ??


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 :slight_smile: ) ?

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

-Mehul Raol