//
archives

cursor

This tag is associated with 8 posts

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

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

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?

Child Cursors

via Why do I have hundreds of child cursors when cursor_sharing is set to similar in 10g (Oracle Optimizer)

Bind Variable Peeking

http://kerryosborne.oracle-guy.com/2009/03/bind-variable-peeking-drives-me-nuts/

SQL Plan Management