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.