I project intermittent appear "ORA - 03111: the communication channel receive interrupt" error, the random error, and lead to a large number of failed transactions,
Is there a big encountered a similar situation?
Environment of the project: oracle + tomcat + jdk1.8

CodePudding user response:

Faced similar, because remember is a single SQL execution time is too long, can also be acquired data (such as the check data of 1000 w), too much can't remember,

Confirm the statement logic and SQL optimization, where is no problem to adjust the timeout time,