What are the consequences of increasing INITTRANS on a table?
In my particular case (using JDBC), I do not want to increase
the INITRANS value since I am NOT doing any DML activity.
I am doing ONLY a SELECT. Hence, I do not want to increase INITTRANS instead (atleast for me, it doesn't make sense to increase this). I want to change the connection mode that JDBC is doing now (from SERIALIZABLE, READ CONSISTENT).
I am sure what is the cause of this problem as I faced the same situation couple of months ago.
1) Are you using EJB, IN the bean properties you have to see that transaction is not set to serializable.
2)INcreasing the INitrans is an option but may not help you all the time
3) Add statement in the Java Code to set transaction read commited explicitly. This will give sure results. Refer the Oracle Documentation for syntax
We are using EJBs as well. I would very much appreciate if you would send me the sample code for item 1 and 3 you have mentioned. I will discuss this option with the Bea Developers over here.
I wouldn't mind increasing the INITTRANS value if we were
doing DML acitivity in these transactions. We are just doing SELECT statements. I hope I am in the right direction???
Please correct me if I am wrong.