inittran and maxtran
I have a table against which updates/inserts are done continuoulsy and there is also a need to delete data from that table on an hourly basis (delete from table where time < today -60min). In order to prevent deadlocks, I plan to set up high values for inittran (based on the expected number of simultanious transaction given by the app team) and maxtran (255). Is there anything else that I need to do to prevent deadlocks? My version is 10.2.0.3
thank you
Gene