Here you find a list of all categories used on this site:
APM Tools [0], Oracle AD4J [1], Quest PerformaSure [1], TVD$XTAT [6], Book Review [4], Java [3], MySQL [1], 8.0.3 [1], Oracle ACE Program [1], Oracle Cloud [7], Autonomous Data Warehouse [3], Object Storage [2], Oracle Database [10], 10gR1 [20], 10gR2 [33], 11gR1 [58], 11gR2 [63], 12cR1 [26], 12.1.0.2 [13], 12cR2 [25], 18c [9], 19c [5], 21c [1], 9iR2 [12], Active Session History (ASH) [3], Adaptive Cursor Sharing [1], Adaptive Query Optimization [6], Adaptive Plans [2], SQL Plan Directives [5], Statistics Feedback [1], Approximate Query Processing [4], Automatic Workload Repository (AWR) [2], Bug [27], Contention [2], Cursor Sharing [1], Direct Path [1], Documentation [6], Exadata [9], In-Memory [3], Indexes [11], Library Cache [3], LogMiner [1], Multitenant [3], Object Statistics [9], Parallel Processing [11], Partitioning [11], PL/SQL [1], RAC [1], RDF Semantic Graph [2], Resource Manager [1], Result Cache [1], SQL Patch [1], SQL Trace [21], System Statistics [3], TKPROF [5], Virtual Private Database [2], PostgreSQL [1], 10.1 [1], Query Optimizer [52], Snowflake [1], Speaking [31], TOP [33], Trivadis [11], Uncategorized [5]
APM Tools [0] ↑
-
Oracle AD4J [1] ↑
- 2009-02-13 Oracle AD4J Installation on Linux
Quest PerformaSure [1] ↑
- 2009-01-05 PerformaSure X-Agent Configuration
TVD$XTAT [6] ↑
- 2017-03-01 TVD$XTAT 4.0 Beta 11
- 2009-08-19 Synthetic Commits and Rollbacks
- 2009-04-09 TVD$XTAT 4.0 Beta 9
- 2009-01-12 Execution Plan Hash Value in SQL Trace Files
- 2008-11-17 TVD$XTAT 4.0 Beta 8
- 2008-10-24 Introduce TVD$XTAT
Book Review [4] ↑
- 2016-05-04 Ad: The Method R Guide to MASTERING ORACLE TRACE DATA
- 2010-11-26 Oracle 11g Streams Implementer’s Guide
- 2010-01-31 The Art of Application Performance Testing
- 2009-03-23 SQL and Relational Theory
Java [3] ↑
- 2011-10-18 Debugging PL/SQL and Java Stored Procedures with JPDA
- 2009-02-13 Oracle AD4J Installation on Linux
- 2009-01-05 PerformaSure X-Agent Configuration
MySQL [1] ↑
- 2017-12-31 How Well a Query Optimizer Handles Subqueries?
8.0.3 [1] ↑
Oracle ACE Program [1] ↑
- 2013-11-22 Oracle ACE Director
Oracle Cloud [7] ↑
- 2018-07-26 Observations About the Scalability of Data Loads in ADWC
- 2018-07-17 Which Privileges Are Required to Use the ADWC Service Console?
- 2018-07-12 DBMS_CLOUD Package - A Reference Guide
- 2017-10-30 The APPROX_MEDIAN Function – A Test Case
- 2016-11-02 Approximate Aggregate Transformation (AAT)
- 2016-10-07 Adaptive Query Optimization Configuration: Parameters, Preferences and Fix Controls
- 2016-09-25 SQL Trace in Oracle Database Exadata Express Cloud Service
Autonomous Data Warehouse [3] ↑
- 2018-07-26 Observations About the Scalability of Data Loads in ADWC
- 2018-07-17 Which Privileges Are Required to Use the ADWC Service Console?
- 2018-07-12 DBMS_CLOUD Package - A Reference Guide
Object Storage [2] ↑
Oracle Database [10] ↑
- 2018-07-12 DBMS_CLOUD Package - A Reference Guide
- 2017-12-31 How Well a Query Optimizer Handles Subqueries?
- 2016-10-26 What's the Difference between Row Migration and Row Chaining?
- 2014-02-26 CBO Days 2014
- 2012-11-28 Ad: CBO Days 2012 - Final Agenda
- 2012-10-24 Does the Parse Time Increase Linearly with the Number Of Child Cursors?
- 2012-09-27 Ad: CBO Days 2012
- 2011-12-18 Ad: The Oracle Query Optimizer 2-Day Seminar
- 2009-10-17 Interpreting Execution Plans
- 2008-12-22 What Are Hints?
10gR1 [20] ↑
- 2012-06-06 Display System Activity without Enterprise Manager
- 2012-03-12 Analysing Row Lock Contention with LogMiner
- 2011-11-29 SQL Trace and Oracle Portal
- 2011-06-20 ITL Waits – Changes in Recent Releases (script)
- 2011-04-13 ITL Waits - Changes in Recent Releases
- 2011-02-17 IS NULL Conditions and B-tree Indexes
- 2010-09-12 Parallel Full Table Scans Do Not Always Perform Direct Reads
- 2010-08-02 Partition-Wise Join of List-Partitioned Tables
- 2010-06-03 Optimizer Mode Mismatch Does Not Prevent Sharing of Child Cursor!?!?
- 2010-04-29 Bind Variable Peeking: Bane or Boon?
- 2010-02-28 Tracing VPD Predicates
- 2010-01-26 Does the Query Optimizer Cost PX Distribution Methods?
- 2009-12-17 Does CREATE INDEX Gather Global Statistics?
- 2009-10-23 Hints for Direct-path Insert Statements
- 2009-08-03 A-Rows and DML Statements - Part 2
- 2009-07-31 A-Rows and DML Statements
- 2009-05-05 Wrong Information about Temporary Space Usage in V$SQL_PLAN_STATISTICS_ALL and DBMS_XPLAN Output
- 2009-05-01 Report Information about CPU Activity in SQL*Plus
- 2008-08-19 SQL Profiles in the Data Dictionary
- 2008-06-17 Operation CONNECT BY WITH FILTERING
10gR2 [33] ↑
- 2015-10-10 Auto SGA Management Impacts the Default Value of DB_FILE_MULTIBLOCK_READ_COUNT
- 2015-09-03 Foreign Keys and Library Cache Locks
- 2013-08-14 The Broken Statistics: "parse count (total)" and "session cursor cache hits"
- 2013-05-01 ITL Deadlocks (script)
- 2012-06-06 Display System Activity without Enterprise Manager
- 2012-04-05 COMMIT_WAIT and COMMIT_LOGGING
- 2012-03-12 Analysing Row Lock Contention with LogMiner
- 2012-02-06 Index Scan with Filter Predicate Based on a Subquery
- 2011-11-29 SQL Trace and Oracle Portal
- 2011-09-11 optimizer_secure_view_merging and VPD
- 2011-06-20 ITL Waits – Changes in Recent Releases (script)
- 2011-04-13 ITL Waits - Changes in Recent Releases
- 2011-04-01 Scripts to Download Documentation
- 2011-02-17 IS NULL Conditions and B-tree Indexes
- 2010-09-12 Parallel Full Table Scans Do Not Always Perform Direct Reads
- 2010-08-02 Partition-Wise Join of List-Partitioned Tables
- 2010-06-03 Optimizer Mode Mismatch Does Not Prevent Sharing of Child Cursor!?!?
- 2010-05-04 Native Full Outer Join Officially Available in 10.2.0.5
- 2010-04-29 Bind Variable Peeking: Bane or Boon?
- 2010-03-08 Inserts Experiencing an Increasing CPU Consumption
- 2010-02-28 Tracing VPD Predicates
- 2010-01-26 Does the Query Optimizer Cost PX Distribution Methods?
- 2010-01-11 Join Elimination
- 2009-12-17 Does CREATE INDEX Gather Global Statistics?
- 2009-10-23 Hints for Direct-path Insert Statements
- 2009-08-03 A-Rows and DML Statements - Part 2
- 2009-07-31 A-Rows and DML Statements
- 2009-05-05 Wrong Information about Temporary Space Usage in V$SQL_PLAN_STATISTICS_ALL and DBMS_XPLAN Output
- 2009-05-01 Report Information about CPU Activity in SQL*Plus
- 2008-09-26 Bloom Filters
- 2008-08-31 Long Parses
- 2008-08-19 SQL Profiles in the Data Dictionary
- 2008-06-17 Operation CONNECT BY WITH FILTERING
11gR1 [58] ↑
- 2016-06-21 When CURSOR_SHARING=FORCE, Does Literal Replacement Always Take Place?
- 2016-03-09 Also Extensions Created Because of SQL Plan Directives Can Invalidate Packages - Take Two
- 2015-12-17 Also Extensions Created Because of SQL Plan Directives Can Invalidate Packages
- 2015-10-10 Auto SGA Management Impacts the Default Value of DB_FILE_MULTIBLOCK_READ_COUNT
- 2015-09-03 Foreign Keys and Library Cache Locks
- 2014-02-05 Extension Bypassed Because of Missing Histogram
- 2013-08-14 The Broken Statistics: "parse count (total)" and "session cursor cache hits"
- 2013-05-01 ITL Deadlocks (script)
- 2012-08-10 Event 10046 - Full List of Levels
- 2012-06-06 Display System Activity without Enterprise Manager
- 2012-04-05 COMMIT_WAIT and COMMIT_LOGGING
- 2012-03-12 Analysing Row Lock Contention with LogMiner
- 2012-02-06 Index Scan with Filter Predicate Based on a Subquery
- 2011-12-12 Challenges and Chances of the 11g Query Optimizer
- 2011-11-29 SQL Trace and Oracle Portal
- 2011-10-18 Debugging PL/SQL and Java Stored Procedures with JPDA
- 2011-10-14 Ad: Der Oracle DBA - Handbuch für die Administration der Oracle Database 11gR2
- 2011-09-19 Impact of STATISTICS_LEVEL on Cardinality Feedback and Adaptive Cursor Sharing
- 2011-09-11 optimizer_secure_view_merging and VPD
- 2011-06-20 ITL Waits – Changes in Recent Releases (script)
- 2011-04-13 ITL Waits - Changes in Recent Releases
- 2011-04-01 Scripts to Download Documentation
- 2011-02-17 IS NULL Conditions and B-tree Indexes
- 2010-10-12 TKPROF New Features in 11gR2 - Release 11.2.0.1
- 2010-09-12 Parallel Full Table Scans Do Not Always Perform Direct Reads
- 2010-08-02 Partition-Wise Join of List-Partitioned Tables
- 2010-06-07 Evolution of a SQL Plan Baseline Based on a DELETE Statement
- 2010-06-03 Optimizer Mode Mismatch Does Not Prevent Sharing of Child Cursor!?!?
- 2010-05-05 Exadata Storage Server and the Query Optimizer - Part 3
- 2010-05-03 Exadata Storage Server and the Query Optimizer – Part 2
- 2010-04-29 Bind Variable Peeking: Bane or Boon?
- 2010-04-28 Exadata Storage Server and the Query Optimizer - Part 1
- 2010-04-27 Analyzing a SQL Trace File with SQL Statements
- 2010-02-28 Tracing VPD Predicates
- 2010-01-26 Does the Query Optimizer Cost PX Distribution Methods?
- 2010-01-11 Join Elimination
- 2009-12-17 Does CREATE INDEX Gather Global Statistics?
- 2009-10-23 Hints for Direct-path Insert Statements
- 2009-08-12 System Managed Extent Size - 11g Improvements
- 2009-08-03 A-Rows and DML Statements - Part 2
- 2009-07-31 A-Rows and DML Statements
- 2009-07-23 Impact of Direct Reads on Delayed Block Cleanouts
- 2009-05-05 Wrong Information about Temporary Space Usage in V$SQL_PLAN_STATISTICS_ALL and DBMS_XPLAN Output
- 2009-05-01 Report Information about CPU Activity in SQL*Plus
- 2009-02-17 Virtual Column-Based Partitioning Might Lead to Wrong Results
- 2009-02-03 11g New Feature in DBMS_MONITOR
- 2009-01-12 Execution Plan Hash Value in SQL Trace Files
- 2008-12-10 Automatic Evolution of SQL Plan Baselines
- 2008-12-02 Query Optimizer 11g – What’s new?
- 2008-11-21 DBMS_XPLAN.PREPARE_PLAN_XML_QUERY
- 2008-11-11 Invisible Indexes and Hints
- 2008-10-17 Invisible Indexes and Locks
- 2008-10-03 Granularity 'APPROX_GLOBAL AND PARTITION'
- 2008-09-26 Bloom Filters
- 2008-09-21 New Information in SQL Trace Files
- 2008-09-11 Long Parses and SQL Plan Baselines
- 2008-08-19 SQL Profiles in the Data Dictionary
- 2008-06-17 Operation CONNECT BY WITH FILTERING
11gR2 [63] ↑
- 2017-07-06 Offline Analysis of ASH Data with ASHDUMP
- 2016-09-17 Statement-level PARALLEL Hint
- 2016-06-21 When CURSOR_SHARING=FORCE, Does Literal Replacement Always Take Place?
- 2016-03-09 Also Extensions Created Because of SQL Plan Directives Can Invalidate Packages - Take Two
- 2015-12-17 Also Extensions Created Because of SQL Plan Directives Can Invalidate Packages
- 2015-10-10 Auto SGA Management Impacts the Default Value of DB_FILE_MULTIBLOCK_READ_COUNT
- 2015-09-03 Foreign Keys and Library Cache Locks
- 2014-02-05 Extension Bypassed Because of Missing Histogram
- 2013-10-06 System Statistics Gathered in Exadata Mode - When Are They Relevant?
- 2013-08-14 The Broken Statistics: "parse count (total)" and "session cursor cache hits"
- 2013-06-13 Named Notation and SEM_MATCH Table Function
- 2013-05-01 ITL Deadlocks (script)
- 2012-10-24 Does the Parse Time Increase Linearly with the Number Of Child Cursors?
- 2012-10-19 How Many Children Can a Parent Cursor Have? 1,000,000?
- 2012-08-10 Event 10046 - Full List of Levels
- 2012-06-06 Display System Activity without Enterprise Manager
- 2012-04-05 COMMIT_WAIT and COMMIT_LOGGING
- 2012-03-12 Analysing Row Lock Contention with LogMiner
- 2012-02-06 Index Scan with Filter Predicate Based on a Subquery
- 2011-12-12 Challenges and Chances of the 11g Query Optimizer
- 2011-11-29 SQL Trace and Oracle Portal
- 2011-10-18 Debugging PL/SQL and Java Stored Procedures with JPDA
- 2011-10-14 Ad: Der Oracle DBA - Handbuch für die Administration der Oracle Database 11gR2
- 2011-09-19 Impact of STATISTICS_LEVEL on Cardinality Feedback and Adaptive Cursor Sharing
- 2011-09-11 optimizer_secure_view_merging and VPD
- 2011-06-20 ITL Waits – Changes in Recent Releases (script)
- 2011-04-13 ITL Waits - Changes in Recent Releases
- 2011-04-01 Scripts to Download Documentation
- 2011-02-17 IS NULL Conditions and B-tree Indexes
- 2010-12-04 Edition-Based Redefinition (update)
- 2010-11-23 Workload System Statistics Bug in 11.2
- 2010-10-13 TKPROF New Features in 11gR2 - 11.2.0.2
- 2010-10-12 TKPROF New Features in 11gR2 - Release 11.2.0.1
- 2010-10-06 DBMS_AUTO_SQLTUNE: ORA-01748 and Documentation Bugs
- 2010-10-05 Deferred Segment Creation as of 11.2.0.2
- 2010-09-12 Parallel Full Table Scans Do Not Always Perform Direct Reads
- 2010-09-01 Parallel Processing With Standard Edition
- 2010-08-09 Exadata Storage Server and the Query Optimizer – Part 4
- 2010-08-04 Partially Index a Table
- 2010-08-02 Partition-Wise Join of List-Partitioned Tables
- 2010-06-10 Related-Combine Operation „UNION ALL (RECURSIVE WITH)“
- 2010-06-07 Evolution of a SQL Plan Baseline Based on a DELETE Statement
- 2010-06-03 Optimizer Mode Mismatch Does Not Prevent Sharing of Child Cursor!?!?
- 2010-05-20 How Good Are the Values Returned by DBMS_COMPRESSION.GET_COMPRESSION_RATIO?
- 2010-05-05 Exadata Storage Server and the Query Optimizer - Part 3
- 2010-05-03 Exadata Storage Server and the Query Optimizer – Part 2
- 2010-04-29 Bind Variable Peeking: Bane or Boon?
- 2010-04-28 Exadata Storage Server and the Query Optimizer - Part 1
- 2010-04-27 Analyzing a SQL Trace File with SQL Statements
- 2010-02-28 Tracing VPD Predicates
- 2010-01-26 Does the Query Optimizer Cost PX Distribution Methods?
- 2010-01-12 Edition-Based Redefinition
- 2010-01-11 Join Elimination
- 2009-12-17 Does CREATE INDEX Gather Global Statistics?
- 2009-11-29 Instance Caging
- 2009-11-25 Zero-Size Unusable Indexes and the Query Optimizer
- 2009-10-23 Hints for Direct-path Insert Statements
- 2009-09-25 Ad: Oracle Database 11g Release 2 Seminars
- 2009-09-09 Script to Download 11gR2 Documentation
- 2009-09-04 Deferred Segment Creation
- 2009-02-17 Virtual Column-Based Partitioning Might Lead to Wrong Results
- 2008-10-17 Invisible Indexes and Locks
- 2008-09-11 Long Parses and SQL Plan Baselines
12cR1 [26] ↑
- 2019-06-28 MIN/MAX Optimization and Asynchronous Global Index Maintenance
- 2019-04-16 V$SQL_CS_HISTOGRAMS: What Are the Buckets’ Thresholds?
- 2017-09-26 Activating and Deactivating Performance Feedback
- 2017-07-06 Offline Analysis of ASH Data with ASHDUMP
- 2016-12-20 Ad - Oracle Database 12c Release 1 and 2: New Performance Features
- 2016-11-11 Initialization Parameters Set at the PDB Level Are Not Always Honored
- 2016-10-13 Trace Files Split in Multiple Parts
- 2016-10-07 Adaptive Query Optimization Configuration: Parameters, Preferences and Fix Controls
- 2016-09-17 Statement-level PARALLEL Hint
- 2016-06-21 When CURSOR_SHARING=FORCE, Does Literal Replacement Always Take Place?
- 2016-03-09 Also Extensions Created Because of SQL Plan Directives Can Invalidate Packages - Take Two
- 2015-12-17 Also Extensions Created Because of SQL Plan Directives Can Invalidate Packages
- 2015-10-10 Auto SGA Management Impacts the Default Value of DB_FILE_MULTIBLOCK_READ_COUNT
- 2015-09-23 Online Training Ad: Oracle Database 12c – New Performance Features
- 2015-09-03 Foreign Keys and Library Cache Locks
- 2015-07-13 Bugs Related to SQL Plan Directives Pack and Unpack
- 2015-01-29 Restrict the query optimizer through OPTIMIZER_FEATURES_ENABLE and Top-Frequency/Hybrid Histograms
- 2014-12-03 STATISTICS COLLECTOR Row Source Operation and LOBs
- 2014-09-04 RESULT_CACHE Hint in 12.1.0.2
- 2014-02-05 Extension Bypassed Because of Missing Histogram
- 2013-12-04 Adaptive Plans in Active Session History
- 2013-10-06 System Statistics Gathered in Exadata Mode - When Are They Relevant?
- 2013-08-14 The Broken Statistics: "parse count (total)" and "session cursor cache hits"
- 2013-07-01 Scripts to Download Oracle Database 12c Release 1 Documentation
- 2008-10-17 Invisible Indexes and Locks
- 2008-09-11 Long Parses and SQL Plan Baselines
12.1.0.2 [13] ↑
- 2020-08-31 AWR Flush Levels
- 2018-01-18 CDB Views and Query Optimizer Cardinality Estimations
- 2017-12-18 Purging Unused Triples Is a Never-ending Operation
- 2017-12-11 SQL_ADAPTIVE_PLAN_RESOLVED Is Broken
- 2017-11-28 SPD State Does Not Change If Adaptive Statistics Are Disabled
- 2016-12-21 Adaptive Query Optimization: Backport of 12.2 Configuration in 12.1.0.2
- 2016-12-20 Ad - Oracle Database 12c Release 1 and 2: New Performance Features
- 2016-04-15 Wrong Results Involving INDEX FULL SCAN (MIN/MAX) in 12.1.0.2
- 2015-12-21 Oracle Database In-Memory Demos
- 2015-09-23 Online Training Ad: Oracle Database 12c – New Performance Features
- 2015-03-24 Exadata Storage Index Min/Max Optimization
- 2014-11-10 The Importance of the In-Memory DUPLICATE Clause for a RAC System
- 2014-10-23 The APPROX_COUNT_DISTINCT Function - A Test Case
12cR2 [25] ↑
- 2022-02-07 Creating a SQL Patch with Many Hints Requires a Hack
- 2020-09-09 AWR: Multitenant-Specific Initialization Parameters
- 2020-08-31 AWR Flush Levels
- 2019-06-28 MIN/MAX Optimization and Asynchronous Global Index Maintenance
- 2019-04-16 V$SQL_CS_HISTOGRAMS: What Are the Buckets’ Thresholds?
- 2018-05-17 Partition-Wise Operations – New Features in 12c and 18c
- 2018-03-21 TKPROF's Argument PDBTRACE
- 2018-01-18 CDB Views and Query Optimizer Cardinality Estimations
- 2017-12-31 How Well a Query Optimizer Handles Subqueries?
- 2017-12-11 SQL_ADAPTIVE_PLAN_RESOLVED Is Broken
- 2017-11-28 SPD State Does Not Change If Adaptive Statistics Are Disabled
- 2017-10-30 The APPROX_MEDIAN Function – A Test Case
- 2017-09-26 Activating and Deactivating Performance Feedback
- 2017-07-06 Offline Analysis of ASH Data with ASHDUMP
- 2017-02-01 Scripts to Download Oracle Database 12c Release 2 Documentation
- 2016-12-21 Adaptive Query Optimization: Backport of 12.2 Configuration in 12.1.0.2
- 2016-12-20 Ad - Oracle Database 12c Release 1 and 2: New Performance Features
- 2016-11-11 Initialization Parameters Set at the PDB Level Are Not Always Honored
- 2016-11-02 Approximate Aggregate Transformation (AAT)
- 2016-10-13 Trace Files Split in Multiple Parts
- 2016-10-07 Adaptive Query Optimization Configuration: Parameters, Preferences and Fix Controls
- 2016-09-25 SQL Trace in Oracle Database Exadata Express Cloud Service
- 2013-12-04 Adaptive Plans in Active Session History
- 2013-08-14 The Broken Statistics: "parse count (total)" and "session cursor cache hits"
- 2008-09-11 Long Parses and SQL Plan Baselines
18c [9] ↑
- 2022-02-07 Creating a SQL Patch with Many Hints Requires a Hack
- 2020-09-09 AWR: Multitenant-Specific Initialization Parameters
- 2020-08-31 AWR Flush Levels
- 2019-06-28 MIN/MAX Optimization and Asynchronous Global Index Maintenance
- 2019-04-16 V$SQL_CS_HISTOGRAMS: What Are the Buckets’ Thresholds?
- 2018-05-17 Partition-Wise Operations – New Features in 12c and 18c
- 2018-03-21 TKPROF's Argument PDBTRACE
- 2018-02-27 Scripts to Download Oracle Database 18c Documentation
- 2017-09-26 Activating and Deactivating Performance Feedback
19c [5] ↑
- 2022-02-07 Creating a SQL Patch with Many Hints Requires a Hack
- 2020-09-09 AWR: Multitenant-Specific Initialization Parameters
- 2020-08-31 AWR Flush Levels
- 2019-06-28 MIN/MAX Optimization and Asynchronous Global Index Maintenance
- 2019-04-16 V$SQL_CS_HISTOGRAMS: What Are the Buckets’ Thresholds?
21c [1] ↑
9iR2 [12] ↑
- 2011-06-20 ITL Waits – Changes in Recent Releases (script)
- 2011-04-13 ITL Waits - Changes in Recent Releases
- 2011-02-17 IS NULL Conditions and B-tree Indexes
- 2010-06-03 Optimizer Mode Mismatch Does Not Prevent Sharing of Child Cursor!?!?
- 2010-04-29 Bind Variable Peeking: Bane or Boon?
- 2010-02-28 Tracing VPD Predicates
- 2010-01-26 Does the Query Optimizer Cost PX Distribution Methods?
- 2009-12-17 Does CREATE INDEX Gather Global Statistics?
- 2009-10-23 Hints for Direct-path Insert Statements
- 2009-08-03 A-Rows and DML Statements - Part 2
- 2009-07-31 A-Rows and DML Statements
- 2008-08-31 Long Parses
Active Session History (ASH) [3] ↑
- 2017-12-11 SQL_ADAPTIVE_PLAN_RESOLVED Is Broken
- 2017-07-06 Offline Analysis of ASH Data with ASHDUMP
- 2013-12-04 Adaptive Plans in Active Session History
Adaptive Cursor Sharing [1] ↑
Adaptive Query Optimization [6] ↑
- 2017-11-28 SPD State Does Not Change If Adaptive Statistics Are Disabled
- 2017-09-26 Activating and Deactivating Performance Feedback
- 2016-12-21 Adaptive Query Optimization: Backport of 12.2 Configuration in 12.1.0.2
- 2016-12-20 Ad - Oracle Database 12c Release 1 and 2: New Performance Features
- 2016-10-07 Adaptive Query Optimization Configuration: Parameters, Preferences and Fix Controls
- 2014-12-03 STATISTICS COLLECTOR Row Source Operation and LOBs
Adaptive Plans [2] ↑
- 2017-12-11 SQL_ADAPTIVE_PLAN_RESOLVED Is Broken
- 2013-12-04 Adaptive Plans in Active Session History
SQL Plan Directives [5] ↑
- 2017-11-28 SPD State Does Not Change If Adaptive Statistics Are Disabled
- 2016-10-07 Adaptive Query Optimization Configuration: Parameters, Preferences and Fix Controls
- 2016-03-09 Also Extensions Created Because of SQL Plan Directives Can Invalidate Packages - Take Two
- 2015-12-17 Also Extensions Created Because of SQL Plan Directives Can Invalidate Packages
- 2015-07-13 Bugs Related to SQL Plan Directives Pack and Unpack
Statistics Feedback [1] ↑
Approximate Query Processing [4] ↑
- 2017-10-30 The APPROX_MEDIAN Function – A Test Case
- 2016-12-20 Ad - Oracle Database 12c Release 1 and 2: New Performance Features
- 2016-11-02 Approximate Aggregate Transformation (AAT)
- 2014-10-23 The APPROX_COUNT_DISTINCT Function - A Test Case
Automatic Workload Repository (AWR) [2] ↑
- 2020-09-09 AWR: Multitenant-Specific Initialization Parameters
- 2020-08-31 AWR Flush Levels
Bug [27] ↑
- 2022-02-07 Creating a SQL Patch with Many Hints Requires a Hack
- 2017-12-18 Purging Unused Triples Is a Never-ending Operation
- 2017-12-11 SQL_ADAPTIVE_PLAN_RESOLVED Is Broken
- 2017-11-28 SPD State Does Not Change If Adaptive Statistics Are Disabled
- 2016-11-11 Initialization Parameters Set at the PDB Level Are Not Always Honored
- 2016-04-15 Wrong Results Involving INDEX FULL SCAN (MIN/MAX) in 12.1.0.2
- 2015-12-17 Also Extensions Created Because of SQL Plan Directives Can Invalidate Packages
- 2015-10-10 Auto SGA Management Impacts the Default Value of DB_FILE_MULTIBLOCK_READ_COUNT
- 2015-07-13 Bugs Related to SQL Plan Directives Pack and Unpack
- 2013-08-14 The Broken Statistics: "parse count (total)" and "session cursor cache hits"
- 2013-06-13 Named Notation and SEM_MATCH Table Function
- 2012-10-19 How Many Children Can a Parent Cursor Have? 1,000,000?
- 2012-08-10 Event 10046 - Full List of Levels
- 2012-02-06 Index Scan with Filter Predicate Based on a Subquery
- 2011-12-12 Challenges and Chances of the 11g Query Optimizer
- 2010-11-23 Workload System Statistics Bug in 11.2
- 2010-10-06 DBMS_AUTO_SQLTUNE: ORA-01748 and Documentation Bugs
- 2010-08-09 Exadata Storage Server and the Query Optimizer – Part 4
- 2010-06-03 Optimizer Mode Mismatch Does Not Prevent Sharing of Child Cursor!?!?
- 2010-05-20 How Good Are the Values Returned by DBMS_COMPRESSION.GET_COMPRESSION_RATIO?
- 2009-07-31 A-Rows and DML Statements
- 2009-05-05 Wrong Information about Temporary Space Usage in V$SQL_PLAN_STATISTICS_ALL and DBMS_XPLAN Output
- 2009-02-17 Virtual Column-Based Partitioning Might Lead to Wrong Results
- 2009-02-13 Oracle AD4J Installation on Linux
- 2008-11-11 Invisible Indexes and Hints
- 2008-08-31 Long Parses
- 2008-06-17 Operation CONNECT BY WITH FILTERING
Contention [2] ↑
- 2015-09-03 Foreign Keys and Library Cache Locks
- 2012-03-12 Analysing Row Lock Contention with LogMiner
Cursor Sharing [1] ↑
Direct Path [1] ↑
- 2009-10-23 Hints for Direct-path Insert Statements
Documentation [6] ↑
- 2018-03-21 TKPROF's Argument PDBTRACE
- 2018-02-27 Scripts to Download Oracle Database 18c Documentation
- 2017-02-01 Scripts to Download Oracle Database 12c Release 2 Documentation
- 2013-07-01 Scripts to Download Oracle Database 12c Release 1 Documentation
- 2011-04-01 Scripts to Download Documentation
- 2009-09-09 Script to Download 11gR2 Documentation
Exadata [9] ↑
- 2015-12-21 Oracle Database In-Memory Demos
- 2015-03-24 Exadata Storage Index Min/Max Optimization
- 2014-11-10 The Importance of the In-Memory DUPLICATE Clause for a RAC System
- 2013-10-06 System Statistics Gathered in Exadata Mode - When Are They Relevant?
- 2010-08-09 Exadata Storage Server and the Query Optimizer – Part 4
- 2010-05-20 How Good Are the Values Returned by DBMS_COMPRESSION.GET_COMPRESSION_RATIO?
- 2010-05-05 Exadata Storage Server and the Query Optimizer - Part 3
- 2010-05-03 Exadata Storage Server and the Query Optimizer – Part 2
- 2010-04-28 Exadata Storage Server and the Query Optimizer - Part 1
In-Memory [3] ↑
- 2016-12-20 Ad - Oracle Database 12c Release 1 and 2: New Performance Features
- 2015-12-21 Oracle Database In-Memory Demos
- 2014-11-10 The Importance of the In-Memory DUPLICATE Clause for a RAC System
Indexes [11] ↑
- 2019-06-28 MIN/MAX Optimization and Asynchronous Global Index Maintenance
- 2016-04-15 Wrong Results Involving INDEX FULL SCAN (MIN/MAX) in 12.1.0.2
- 2015-03-24 Exadata Storage Index Min/Max Optimization
- 2011-12-12 Challenges and Chances of the 11g Query Optimizer
- 2011-02-17 IS NULL Conditions and B-tree Indexes
- 2010-09-12 Parallel Full Table Scans Do Not Always Perform Direct Reads
- 2010-08-04 Partially Index a Table
- 2009-12-17 Does CREATE INDEX Gather Global Statistics?
- 2009-11-25 Zero-Size Unusable Indexes and the Query Optimizer
- 2008-11-11 Invisible Indexes and Hints
- 2008-10-17 Invisible Indexes and Locks
Library Cache [3] ↑
- 2015-09-03 Foreign Keys and Library Cache Locks
- 2012-10-24 Does the Parse Time Increase Linearly with the Number Of Child Cursors?
- 2012-10-19 How Many Children Can a Parent Cursor Have? 1,000,000?
LogMiner [1] ↑
- 2012-03-12 Analysing Row Lock Contention with LogMiner
Multitenant [3] ↑
- 2020-09-09 AWR: Multitenant-Specific Initialization Parameters
- 2018-01-18 CDB Views and Query Optimizer Cardinality Estimations
- 2016-11-11 Initialization Parameters Set at the PDB Level Are Not Always Honored
Object Statistics [9] ↑
- 2018-01-18 CDB Views and Query Optimizer Cardinality Estimations
- 2017-11-28 SPD State Does Not Change If Adaptive Statistics Are Disabled
- 2016-03-09 Also Extensions Created Because of SQL Plan Directives Can Invalidate Packages - Take Two
- 2015-12-17 Also Extensions Created Because of SQL Plan Directives Can Invalidate Packages
- 2015-01-29 Restrict the query optimizer through OPTIMIZER_FEATURES_ENABLE and Top-Frequency/Hybrid Histograms
- 2014-02-05 Extension Bypassed Because of Missing Histogram
- 2011-12-12 Challenges and Chances of the 11g Query Optimizer
- 2009-12-17 Does CREATE INDEX Gather Global Statistics?
- 2008-10-03 Granularity 'APPROX_GLOBAL AND PARTITION'
Parallel Processing [11] ↑
- 2018-07-26 Observations About the Scalability of Data Loads in ADWC
- 2018-05-17 Partition-Wise Operations – New Features in 12c and 18c
- 2017-09-26 Activating and Deactivating Performance Feedback
- 2016-09-17 Statement-level PARALLEL Hint
- 2014-11-10 The Importance of the In-Memory DUPLICATE Clause for a RAC System
- 2010-09-12 Parallel Full Table Scans Do Not Always Perform Direct Reads
- 2010-09-01 Parallel Processing With Standard Edition
- 2010-05-05 Exadata Storage Server and the Query Optimizer - Part 3
- 2010-01-26 Does the Query Optimizer Cost PX Distribution Methods?
- 2009-08-12 System Managed Extent Size - 11g Improvements
- 2008-09-26 Bloom Filters
Partitioning [11] ↑
- 2019-06-28 MIN/MAX Optimization and Asynchronous Global Index Maintenance
- 2018-05-17 Partition-Wise Operations – New Features in 12c and 18c
- 2016-04-15 Wrong Results Involving INDEX FULL SCAN (MIN/MAX) in 12.1.0.2
- 2010-10-05 Deferred Segment Creation as of 11.2.0.2
- 2010-08-04 Partially Index a Table
- 2010-08-02 Partition-Wise Join of List-Partitioned Tables
- 2009-12-17 Does CREATE INDEX Gather Global Statistics?
- 2009-11-25 Zero-Size Unusable Indexes and the Query Optimizer
- 2009-02-17 Virtual Column-Based Partitioning Might Lead to Wrong Results
- 2008-10-03 Granularity 'APPROX_GLOBAL AND PARTITION'
- 2008-09-26 Bloom Filters
PL/SQL [1] ↑
- 2016-03-09 Also Extensions Created Because of SQL Plan Directives Can Invalidate Packages - Take Two
RAC [1] ↑
RDF Semantic Graph [2] ↑
- 2017-12-18 Purging Unused Triples Is a Never-ending Operation
- 2013-06-13 Named Notation and SEM_MATCH Table Function
Resource Manager [1] ↑
- 2009-11-29 Instance Caging
Result Cache [1] ↑
- 2014-09-04 RESULT_CACHE Hint in 12.1.0.2
SQL Patch [1] ↑
SQL Trace [21] ↑
- 2017-03-01 TVD$XTAT 4.0 Beta 11
- 2016-10-13 Trace Files Split in Multiple Parts
- 2016-09-25 SQL Trace in Oracle Database Exadata Express Cloud Service
- 2016-05-04 Ad: The Method R Guide to MASTERING ORACLE TRACE DATA
- 2014-11-10 The Importance of the In-Memory DUPLICATE Clause for a RAC System
- 2012-08-10 Event 10046 - Full List of Levels
- 2012-06-11 Ad: Mastering Oracle Trace Data
- 2011-11-29 SQL Trace and Oracle Portal
- 2010-10-13 TKPROF New Features in 11gR2 - 11.2.0.2
- 2010-10-12 TKPROF New Features in 11gR2 - Release 11.2.0.1
- 2010-06-07 Evolution of a SQL Plan Baseline Based on a DELETE Statement
- 2010-06-03 Optimizer Mode Mismatch Does Not Prevent Sharing of Child Cursor!?!?
- 2010-04-27 Analyzing a SQL Trace File with SQL Statements
- 2010-03-08 Inserts Experiencing an Increasing CPU Consumption
- 2009-08-19 Synthetic Commits and Rollbacks
- 2009-04-09 TVD$XTAT 4.0 Beta 9
- 2009-02-03 11g New Feature in DBMS_MONITOR
- 2009-01-12 Execution Plan Hash Value in SQL Trace Files
- 2008-11-17 TVD$XTAT 4.0 Beta 8
- 2008-10-24 Introduce TVD$XTAT
- 2008-09-21 New Information in SQL Trace Files
System Statistics [3] ↑
- 2013-10-06 System Statistics Gathered in Exadata Mode - When Are They Relevant?
- 2011-12-12 Challenges and Chances of the 11g Query Optimizer
- 2010-11-23 Workload System Statistics Bug in 11.2
TKPROF [5] ↑
- 2018-03-21 TKPROF's Argument PDBTRACE
- 2010-10-13 TKPROF New Features in 11gR2 - 11.2.0.2
- 2010-10-12 TKPROF New Features in 11gR2 - Release 11.2.0.1
- 2010-04-27 Analyzing a SQL Trace File with SQL Statements
- 2008-10-24 Introduce TVD$XTAT
Virtual Private Database [2] ↑
- 2011-09-11 optimizer_secure_view_merging and VPD
- 2010-02-28 Tracing VPD Predicates
PostgreSQL [1] ↑
- 2017-12-31 How Well a Query Optimizer Handles Subqueries?
10.1 [1] ↑
Query Optimizer [52] ↑
- 2022-02-07 Creating a SQL Patch with Many Hints Requires a Hack
- 2019-06-28 MIN/MAX Optimization and Asynchronous Global Index Maintenance
- 2018-05-17 Partition-Wise Operations – New Features in 12c and 18c
- 2018-01-18 CDB Views and Query Optimizer Cardinality Estimations
- 2017-12-31 How Well a Query Optimizer Handles Subqueries?
- 2017-11-28 SPD State Does Not Change If Adaptive Statistics Are Disabled
- 2016-12-20 Ad - Oracle Database 12c Release 1 and 2: New Performance Features
- 2016-11-02 Approximate Aggregate Transformation (AAT)
- 2016-10-07 Adaptive Query Optimization Configuration: Parameters, Preferences and Fix Controls
- 2016-09-17 Statement-level PARALLEL Hint
- 2016-06-21 When CURSOR_SHARING=FORCE, Does Literal Replacement Always Take Place?
- 2016-04-15 Wrong Results Involving INDEX FULL SCAN (MIN/MAX) in 12.1.0.2
- 2015-07-13 Bugs Related to SQL Plan Directives Pack and Unpack
- 2015-01-29 Restrict the query optimizer through OPTIMIZER_FEATURES_ENABLE and Top-Frequency/Hybrid Histograms
- 2014-12-03 STATISTICS COLLECTOR Row Source Operation and LOBs
- 2014-02-26 CBO Days 2014
- 2014-02-05 Extension Bypassed Because of Missing Histogram
- 2013-12-04 Adaptive Plans in Active Session History
- 2013-10-06 System Statistics Gathered in Exadata Mode - When Are They Relevant?
- 2012-11-28 Ad: CBO Days 2012 - Final Agenda
- 2012-09-27 Ad: CBO Days 2012
- 2012-02-06 Index Scan with Filter Predicate Based on a Subquery
- 2011-12-18 Ad: The Oracle Query Optimizer 2-Day Seminar
- 2011-12-12 Challenges and Chances of the 11g Query Optimizer
- 2011-09-19 Impact of STATISTICS_LEVEL on Cardinality Feedback and Adaptive Cursor Sharing
- 2011-09-11 optimizer_secure_view_merging and VPD
- 2011-02-17 IS NULL Conditions and B-tree Indexes
- 2010-10-06 DBMS_AUTO_SQLTUNE: ORA-01748 and Documentation Bugs
- 2010-08-09 Exadata Storage Server and the Query Optimizer – Part 4
- 2010-08-02 Partition-Wise Join of List-Partitioned Tables
- 2010-06-10 Related-Combine Operation „UNION ALL (RECURSIVE WITH)“
- 2010-06-07 Evolution of a SQL Plan Baseline Based on a DELETE Statement
- 2010-06-03 Optimizer Mode Mismatch Does Not Prevent Sharing of Child Cursor!?!?
- 2010-05-05 Exadata Storage Server and the Query Optimizer - Part 3
- 2010-05-04 Native Full Outer Join Officially Available in 10.2.0.5
- 2010-05-03 Exadata Storage Server and the Query Optimizer – Part 2
- 2010-04-29 Bind Variable Peeking: Bane or Boon?
- 2010-04-28 Exadata Storage Server and the Query Optimizer - Part 1
- 2010-01-26 Does the Query Optimizer Cost PX Distribution Methods?
- 2010-01-11 Join Elimination
- 2009-11-25 Zero-Size Unusable Indexes and the Query Optimizer
- 2009-10-17 Interpreting Execution Plans
- 2008-12-22 What Are Hints?
- 2008-12-10 Automatic Evolution of SQL Plan Baselines
- 2008-12-02 Query Optimizer 11g – What’s new?
- 2008-11-21 DBMS_XPLAN.PREPARE_PLAN_XML_QUERY
- 2008-11-11 Invisible Indexes and Hints
- 2008-09-26 Bloom Filters
- 2008-09-11 Long Parses and SQL Plan Baselines
- 2008-08-31 Long Parses
- 2008-08-19 SQL Profiles in the Data Dictionary
- 2008-06-17 Operation CONNECT BY WITH FILTERING
Snowflake [1] ↑
Speaking [31] ↑
- 2016-12-20 Ad - Oracle Database 12c Release 1 and 2: New Performance Features
- 2015-12-21 Oracle Database In-Memory Demos
- 2015-09-23 Online Training Ad: Oracle Database 12c – New Performance Features
- 2015-03-30 Ad: Trivadis DK Opening Event
- 2014-03-28 Upcoming Speaking Engagements
- 2014-02-26 CBO Days 2014
- 2012-11-28 Ad: CBO Days 2012 - Final Agenda
- 2012-09-27 Ad: CBO Days 2012
- 2012-06-11 Ad: Mastering Oracle Trace Data
- 2011-12-18 Ad: The Oracle Query Optimizer 2-Day Seminar
- 2011-12-12 Challenges and Chances of the 11g Query Optimizer
- 2011-05-23 Ad: DOAG Berliner Expertenseminare (Last Call)
- 2011-03-01 Ad: Trivadis Performance Days 2011
- 2010-10-05 UKOUG Conference in Birmingham
- 2010-09-01 DOAG Conference in Nürnberg
- 2010-09-01 Oracle OpenWorld Schedule - Update
- 2010-08-10 SIOUG Conference in Portoroz
- 2010-07-13 Oracle OpenWorld Schedule
- 2010-05-22 Ad: Optimizing Oracle Performance Seminar in Berlin
- 2010-05-10 AOUG Conference in Vienna
- 2010-04-12 Michigan OakTable Symposium 2010
- 2009-10-17 Interpreting Execution Plans
- 2009-09-25 Ad: Oracle Database 11g Release 2 Seminars
- 2009-08-16 Upcoming Speaking Engagements
- 2009-04-20 Upcoming Speaking Engagements
- 2009-02-14 Upcoming Speaking Engagements
- 2008-12-02 Query Optimizer 11g – What’s new?
- 2008-11-13 Hotsos Symposium 2009
- 2008-09-23 Book Presentation
- 2008-09-18 Upcoming Speaking Engagements
- 2008-07-08 Ad: Tanel Poder's Seminars in Europe
TOP [33] ↑
- 2017-03-01 TVD$XTAT 4.0 Beta 11
- 2015-10-10 Auto SGA Management Impacts the Default Value of DB_FILE_MULTIBLOCK_READ_COUNT
- 2014-12-04 UKOUG TECH14 SQL Quiz
- 2014-06-05 Differences between the First and the Second Edition of Troubleshooting Oracle Performance
- 2014-06-01 Troubleshooting Oracle Performance, 2nd Edition
- 2013-03-14 Premature Optimization
- 2012-02-06 Index Scan with Filter Predicate Based on a Subquery
- 2011-12-18 Ad: The Oracle Query Optimizer 2-Day Seminar
- 2011-09-11 optimizer_secure_view_merging and VPD
- 2011-05-23 Ad: DOAG Berliner Expertenseminare (Last Call)
- 2011-02-17 IS NULL Conditions and B-tree Indexes
- 2010-08-10 SIOUG Conference in Portoroz
- 2010-07-13 Oracle OpenWorld Schedule
- 2010-06-24 Troubleshooting Oracle Performance - Downloadable Files
- 2010-06-10 Related-Combine Operation „UNION ALL (RECURSIVE WITH)“
- 2010-05-22 Ad: Optimizing Oracle Performance Seminar in Berlin
- 2009-12-18 Chinese Edition of TOP Available!
- 2009-10-17 Interpreting Execution Plans
- 2009-07-31 A-Rows and DML Statements
- 2009-05-29 Troubleshooting Oracle Performance - Downloadable Files
- 2009-05-05 Wrong Information about Temporary Space Usage in V$SQL_PLAN_STATISTICS_ALL and DBMS_XPLAN Output
- 2009-04-09 TVD$XTAT 4.0 Beta 9
- 2009-03-08 Troubleshooting Oracle Performance - Downloadable Files
- 2008-12-22 What Are Hints?
- 2008-12-10 Automatic Evolution of SQL Plan Baselines
- 2008-11-17 TVD$XTAT 4.0 Beta 8
- 2008-10-24 Introduce TVD$XTAT
- 2008-10-10 TOP on Google Book Search
- 2008-09-23 Book Presentation
- 2008-09-06 TOP: Addenda and Errata
- 2008-08-21 TOP: Downloadable Files Are Available
- 2008-07-07 TOP Is At Last Available
- 2008-06-17 Operation CONNECT BY WITH FILTERING
Trivadis [11] ↑
- 2015-09-23 Online Training Ad: Oracle Database 12c – New Performance Features
- 2015-03-30 Ad: Trivadis DK Opening Event
- 2014-03-28 Upcoming Speaking Engagements
- 2014-02-26 CBO Days 2014
- 2012-11-28 Ad: CBO Days 2012 - Final Agenda
- 2012-09-27 Ad: CBO Days 2012
- 2012-06-11 Ad: Mastering Oracle Trace Data
- 2011-12-01 Ad: Trivadis TechEvent 2011
- 2011-03-01 Ad: Trivadis Performance Days 2011
- 2009-09-25 Ad: Oracle Database 11g Release 2 Seminars
- 2008-07-08 Ad: Tanel Poder's Seminars in Europe
Uncategorized [5] ↑
- 2014-11-06 About Oracle’s Code of Ethics, MOS Confidentiality Clause, and Content Stolen from My Website
- 2009-07-25 ORA-00001: unique constraint (METALINK.SYS_C005417) violated
- 2009-02-09 New Infrastructure
- 2008-09-08 No Space Left on Device
- 2008-05-31 Never Say Never