//
archives

tuning

This tag is associated with 12 posts

Filter and Access in Execution Plan

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

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)

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

Automatic SQL Tuning and SQL Profile

Database Concepts and Internals by Ashish: Automatic SQL Tunig and SQL Profile.

Q: The most fundamental difference between HASH and NESTED LOOP joins? | Tanel Poder’s blog: Responsible data management

Q: The most fundamental difference between HASH and NESTED LOOP joins? | Tanel Poder's blog: Responsible data management.

How the Clustering Factor Impacts SQL Statements in Oracle 11g | A Confio Resource

The CLUSTERING_FACTOR column in the USER_INDEXES view gives an indication as to how organized the data is compared to the indexed columns. If the value of the CLUSTERING_FACTOR column value is close to the number of leaf blocks in the index, the data is well ordered in the table. If the value is not close to the number of leaf blocks in the index, then the data in the table is not well ordered. The leaf blocks of an index store the indexed values as well as the ROWIDs to which they point.

via How the Clustering Factor Impacts SQL Statements in Oracle 11g | A Confio Resource.