custom vs. generic plans With my Oracle database background, I know how important it is to balance the pros and cons of using bind variables…
View More PostgreSQL “bind variable peeking”
Tag: cursor sharing
Adaptive Cursor Sharing in Oracle Database 11g Release 1
DBAs are always encouraging developers to use bind variables, but when bind variables are used against columns containing skewed data they sometimes lead to less…
View More Adaptive Cursor Sharing in Oracle Database 11g Release 1
CURSOR_SHARING(EXACT/FORCE/SIMILAR) In ORACLE
How CURSOR_SHARING works in ORACLE?CURSOR_SHARING determines what kind of SQL statements can share the same cursors. The possible values are EXACT which is the default value and…
View More CURSOR_SHARING(EXACT/FORCE/SIMILAR) In ORACLE