via Explain adaptive cursor sharing behavior with cursor_sharing = similar and force. (Oracle Optimizer)
via Kerry Osborne’s Oracle Blog » Blog Archive » Oracle 11g Adaptive Cursor Sharing (ACS) – Kerry Osborne’s Oracle Blog
via CURSOR SHARING DEMYSTIFIED – ORACLE IN ACTION
via PARENT AND CHILD CURSORS IN ORACLE – ORACLE IN ACTION
via Inside the Oracle Optimizer – Removing the black magic: Why are there more cursors in 11g for my query containing bind variables?
via Why do I have hundreds of child cursors when cursor_sharing is set to similar in 10g (Oracle Optimizer)
Links to Various sources
Create a free website or blog at WordPress.com.