//
archives

performance

This tag is associated with 26 posts

Filter and Access in Execution Plan

https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:7807480400346035212

Advertisements

Combined Access and Filter Predicates

http://oracle-randolf.blogspot.sg/2015/04/combined-access-and-filter-predicates.html

Dynamic sampling and its impact on the Optimizer (Oracle Optimizer)

via Dynamic sampling and its impact on the Optimizer (Oracle Optimizer)

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

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?