//
archives

cursorsharing

This tag is associated with 8 posts

Stabilize Oracle 10G’s Bind Peeking Behaviour

https://www.pythian.com/blog/stabilize-oracle-10gs-bind-peeking-behaviour/

Explain adaptive cursor sharing behavior with cursor_sharing = similar and force.

via Explain adaptive cursor sharing behavior with cursor_sharing = similar and force. (Oracle Optimizer)

Oracle 11g Adaptive Cursor Sharing (ACS)

 

via Kerry Osborne’s Oracle Blog » Blog Archive » Oracle 11g Adaptive Cursor Sharing (ACS) – Kerry Osborne’s Oracle Blog

Bind variable peeking in 11G

via Oracle Today: Bind variable peeking in 11G

CURSOR SHARING DEMYSTIFIED

via CURSOR SHARING DEMYSTIFIED – ORACLE IN ACTION

Parent and Child Cursors In Oracle

via PARENT AND CHILD CURSORS IN ORACLE – ORACLE IN ACTION

Literal, bind variable and adaptive cursor sharing: simplify them please

via Literal, bind variable and adaptive cursor sharing: simplify them please!!! | Mohamed Houri’s Oracle Notes

Why are there more cursors in 11g for my query containing bind variables

via Inside the Oracle Optimizer – Removing the black magic: Why are there more cursors in 11g for my query containing bind variables?