Oracle Blog
- [2021-09] How to split comma separated value strings into rows in Oracle Database
- [2021-02] JSON DataType Support in Oracle 21c
- [2020-12] Efficient Statistics Maintenance for Partitioned Tables Using Incremental Statistics – Part 1
- [2020-05] Space Management and Direct Path Load
- [2020-01] Optimizer Transformations: Star Transformation
- [2017-03] Efficient Statistics Maintenance for Partitioned Tables Using Incremental Statistics – Part 3
- [2017-01] Efficient Statistics Maintenance for Partitioned Tables Using Incremental Statistics – Part 2
- [2016-08] Parallel PL/SQL Functions and Global Temporary Tables... and Wrong Results
- [2016-06] Adaptive Distribution Methods in Oracle Database 12c
- [2016-05] Single PX Server Execution
- [2016-04] Common Distribution Methods in Parallel Execution
- [2016-03] In-Memory Parallel Query
- [2016-01] Parallel Correlated Filters and Expressions in 12c
- [2015-12] Multiple Parallelizers
- [2015-11] PX Server Sets, Parallelizers, DFO Trees, Parallel Groups, ... Let's Talk About Terminology
- [2015-10] DOP Downgrades, or Avoid The Ceiling
- [2015-09] Optimizer Processing Rates for Auto DOP
- [2015-08] Configuring and Controlling Auto DOP
- [2015-08] System Statistics About DOP Downgrades
- [2015-08] What is Auto DOP?
- [2015-07] Parallel_Degree_Limit, Parallel_Max_Degree, Maximum DOP? Confused?
- [2015-05] Monitoring Parallel Execution using Real-Time SQL Monitoring in Oracle Database 12c
- [2015-05] PX In Memory, PX In Memory IMC?
- [2015-03] Finding the Distribution Method in Adaptive Parallel Joins
- [2015-03] Finding the Reason for DOP Downgrades
- [2015-03] Parallel DML on Tables with LOB Columns
- [2015-02] New Way to Enable Parallel DML
- [2014-11] Optimizing Table Scans with Zone Maps
- [2014-10] Optimizing Queries with Attribute Clustering
Technical Article
- [2012-12] Understanding Parallel Execution - Part 1
- [2012-12] Understanding Parallel Execution - Part 2