What is the impact/limitation of oracle select with large number of bind variables?
- by Igal Serban
We had our oracle server chocking during processing a select statement with close to 3500(!!) bind variables.
This select is, obviously, build dynamically by code that we can't change. During the execution of this select the db server went to 100% cpu usage and our system almost halted.
We know how to reproduce this problem. So we can prevent this specific condition. But I am wondering if there is a way to protect the db ( by configuration) from this type of problems.