Error Can't serliase access for the transaction
-
Hi all, I am using oracle transactions in c#.net in .net frameowrk 2008.The WCF web application giving error "Can't serialize access for the transaction" when multiple user searches for same record in a table in Oracle 11g can anybody tell how can it be resolved.I have increased the initrans value to 100 it is not giving error now, but what if the user gets above 1000 limit.will initrans works. Thanks in advance.
-
Hi all, I am using oracle transactions in c#.net in .net frameowrk 2008.The WCF web application giving error "Can't serialize access for the transaction" when multiple user searches for same record in a table in Oracle 11g can anybody tell how can it be resolved.I have increased the initrans value to 100 it is not giving error now, but what if the user gets above 1000 limit.will initrans works. Thanks in advance.
"The maximum value suggested for INITRANS is 100 and settings over this size rarely improve performance. Therefore a setting of INITRANS to the average number of simultaneous DML users and setting MAXTRANS to 100 will most likely result in the best utilization of resources and performance"[^].
"When did ignorance become a point of view" - Dilbert