11.1.0.7

New Version Of XPLAN_ASH Tool - Video Tutorial

"Cost-free" joins - 1

New Version Of XPLAN_ASH Utility

Parallel Execution Analysis Using ASH - The XPLAN_ASH Tool

Table Functions And Join Cardinality Estimates

Logical I/O Evolution - Part 3: 11g

Multi-Column Joins, Expressions and 11g

Flashback Query "AS OF" - Tablescan costs

Transitive Closure - Outer Joins

ASSM bug reprise - part 2

ASSM bug reprise - part 1

Things worth to mention and remember (II) - Parallel Execution Control 2

Parallel DML - Conventional (non-direct-path) Inserts As Select

Concurrent Index Creation

Quiz Night

Pending Statistics

Hash Aggregation

Adaptive Cursor Sharing

Cleanup of partitioned objects residing in offlined tablespaces

Time Model Bug

Compression Restrictions

DBMS_STATS - Gather table statistics with many columns

Advanced Oracle Troubleshooting Session - PGA/UGA memory fragmentation

Frequency histograms - edge cases

TEMP Table Transformation and Remote Procedure Calls

Multi-column joins

Optimizer cleverness

Locked table statistics and subsequent create index

Temporary Tablespace Groups

User objects created in the SYS schema and the (cost based) optimizer