Striving for Optimal Performance

Home
Blog
- Archive
- Categories
Troubleshooting Oracle Performance
Publications
Public Appearances
- Past Public Appearances
Contact
Search
About

Archives

Here you find a list of all my posts:

June 2013 (1)
- 13: Named Notation and SEM_MATCH Table Function (4)
May 2013 (1)
- 01: ITL Deadlocks (script) (1)
March 2013 (1)
- 14: Premature Optimization (4)
November 2012 (1)
- 28: Ad: CBO Days 2012 – Final Agenda (3)
October 2012 (2)
- 24: Does the Parse Time Increase Linearly with the Number Of Child Cursors? (1)
- 19: How Many Children Can a Parent Cursor Have? 1,000,000? (2)
September 2012 (1)
- 27: Ad: CBO Days 2012 (0)
August 2012 (1)
- 10: Event 10046 – Full List of Levels (0)
June 2012 (2)
- 11: Ad: Mastering Oracle Trace Data (0)
- 06: Display System Activity without Enterprise Manager (11)
April 2012 (1)
- 05: COMMIT_WAIT and COMMIT_LOGGING (13)
March 2012 (1)
- 12: Analysing Row Lock Contention with LogMiner (9)
February 2012 (1)
- 06: Index Scan with Filter Predicate Based on a Subquery (4)
December 2011 (3)
- 18: Ad: The Oracle Query Optimizer 2-Day Seminar (0)
- 12: Challenges and Chances of the 11g Query Optimizer (2)
- 01: Ad: Trivadis TechEvent 2011 (1)
November 2011 (1)
- 29: SQL Trace and Oracle Portal (2)
October 2011 (2)
- 18: Debugging PL/SQL and Java Stored Procedures with JPDA (0)
- 14: Ad: Der Oracle DBA – Handbuch für die Administration der Oracle Database 11gR2 (6)
September 2011 (2)
- 19: Impact of STATISTICS_LEVEL on Cardinality Feedback and Adaptive Cursor Sharing (7)
- 11: optimizer_secure_view_merging and VPD (10)
June 2011 (1)
- 20: ITL Waits – Changes in Recent Releases (script) (8)
May 2011 (1)
- 23: Ad: DOAG Berliner Expertenseminare (Last Call) (4)
April 2011 (2)
- 13: ITL Waits – Changes in Recent Releases (6)
- 01: Scripts to Download Documentation (6)
March 2011 (1)
- 01: Ad: Trivadis Performance Days 2011 (0)
February 2011 (1)
- 17: IS NULL Conditions and B-tree Indexes (2)
December 2010 (1)
- 04: Edition-Based Redefinition (update) (4)
November 2010 (2)
- 26: Oracle 11g Streams Implementer’s Guide (1)
- 23: Workload System Statistics Bug in 11.2 (6)
October 2010 (5)
- 13: TKPROF New Features in 11gR2 – 11.2.0.2 (3)
- 12: TKPROF New Features in 11gR2 – Release 11.2.0.1 (3)
- 06: DBMS_AUTO_SQLTUNE: ORA-01748 and Documentation Bugs (2)
- 05: UKOUG Conference in Birmingham (0)
- 05: Deferred Segment Creation as of 11.2.0.2 (8)
September 2010 (4)
- 12: Parallel Full Table Scans Do Not Always Perform Direct Reads (5)
- 01: DOAG Conference in Nürnberg (1)
- 01: Oracle OpenWorld Schedule – Update (2)
- 01: Parallel Processing With Standard Edition (12)
August 2010 (4)
- 10: SIOUG Conference in Portoroz (0)
- 09: Exadata Storage Server and the Query Optimizer – Part 4 (2)
- 04: Partially Index a Table (9)
- 02: Partition-Wise Join of List-Partitioned Tables (3)
July 2010 (1)
- 13: Oracle OpenWorld Schedule (2)
June 2010 (4)
- 24: Troubleshooting Oracle Performance – Downloadable Files (7)
- 10: Related-Combine Operation „UNION ALL (RECURSIVE WITH)“ (4)
- 07: Evolution of a SQL Plan Baseline Based on a DELETE Statement (4)
- 03: Optimizer Mode Mismatch Does Not Prevent Sharing of Child Cursor!?!? (4)
May 2010 (6)
- 22: Ad: Optimizing Oracle Performance Seminar in Berlin (0)
- 20: How Good Are the Values Returned by DBMS_COMPRESSION.GET_COMPRESSION_RATIO? (12)
- 10: AOUG Conference in Vienna (0)
- 05: Exadata Storage Server and the Query Optimizer – Part 3 (2)
- 04: Native Full Outer Join Officially Available in 10.2.0.5 (4)
- 03: Exadata Storage Server and the Query Optimizer – Part 2 (5)
April 2010 (4)
- 29: Bind Variable Peeking: Bane or Boon? (1)
- 28: Exadata Storage Server and the Query Optimizer – Part 1 (12)
- 27: Analyzing a SQL Trace File with SQL Statements (8)
- 12: Michigan OakTable Symposium 2010 (1)
March 2010 (1)
- 08: Inserts Experiencing an Increasing CPU Consumption (7)
February 2010 (1)
- 28: Tracing VPD Predicates (2)
January 2010 (4)
- 31: The Art of Application Performance Testing (1)
- 26: Does the Query Optimizer Cost PX Distribution Methods? (13)
- 12: Edition-Based Redefinition (7)
- 11: Join Elimination (14)
December 2009 (2)
- 18: Chinese Edition of TOP Available! (3)
- 17: Does CREATE INDEX Gather Global Statistics? (4)
November 2009 (2)
- 29: Instance Caging (10)
- 25: Zero-Size Unusable Indexes and the Query Optimizer (10)
October 2009 (2)
- 23: Hints for Direct-path Insert Statements (12)
- 17: Interpreting Execution Plans (2)
September 2009 (3)
- 25: Ad: Oracle Database 11g Release 2 Seminars (2)
- 09: Script to Download 11gR2 Documentation (9)
- 04: Deferred Segment Creation (24)
August 2009 (4)
- 19: Synthetic Commits and Rollbacks (3)
- 16: Upcoming Speaking Engagements (2)
- 12: System Managed Extent Size – 11g Improvements (17)
- 03: A-Rows and DML Statements – Part 2 (0)
July 2009 (3)
- 31: A-Rows and DML Statements (4)
- 25: ORA-00001: unique constraint (METALINK.SYS_C005417) violated (3)
- 23: Impact of Direct Reads on Delayed Block Cleanouts (29)
May 2009 (3)
- 29: Troubleshooting Oracle Performance – Downloadable Files (0)
- 05: Wrong Information about Temporary Space Usage in V$SQL_PLAN_STATISTICS_ALL and DBMS_XPLAN Output (10)
- 01: Report Information about CPU Activity in SQL*Plus (22)
April 2009 (2)
- 20: Upcoming Speaking Engagements (0)
- 09: TVD$XTAT 4.0 Beta 9 (10)
March 2009 (2)
- 23: SQL and Relational Theory (5)
- 08: Troubleshooting Oracle Performance – Downloadable Files (1)
February 2009 (5)
- 17: Virtual Column-Based Partitioning Might Lead to Wrong Results (3)
- 14: Upcoming Speaking Engagements (0)
- 13: Oracle AD4J Installation on Linux (6)
- 09: New Infrastructure (0)
- 03: 11g New Feature in DBMS_MONITOR (2)
January 2009 (2)
- 12: Execution Plan Hash Value in SQL Trace Files (4)
- 05: PerformaSure X-Agent Configuration (3)
December 2008 (3)
- 22: What Are Hints?
- 10: Automatic Evolution of SQL Plan Baselines (13)
- 02: Query Optimizer 11g – What’s new? (4)
November 2008 (4)
- 21: DBMS_XPLAN.PREPARE_PLAN_XML_QUERY (0)
- 17: TVD$XTAT 4.0 Beta 8 (1)
- 13: Hotsos Symposium 2009 (0)
- 11: Invisible Indexes and Hints (5)
October 2008 (4)
- 24: Introduce TVD$XTAT (11)
- 17: Invisible Indexes and Locks (6)
- 10: TOP on Google Book Search (2)
- 03: Granularity 'APPROX_GLOBAL AND PARTITION' (2)
September 2008 (7)
- 26: Bloom Filters (11)
- 23: Book Presentation (0)
- 21: New Information in SQL Trace Files (3)
- 18: Upcoming Speaking Engagements (0)
- 11: Long Parses and SQL Plan Baselines (0)
- 08: No Space Left on Device (0)
- 06: TOP: Addenda and Errata (0)
August 2008 (3)
- 31: Long Parses (6)
- 21: TOP: Downloadable Files Are Available (0)
- 19: SQL Profiles in the Data Dictionary (4)
July 2008 (3)
- 11: TOP: Front Matter and Chapter 1 (0)
- 08: Ad: Tanel Poder's Seminars in Europe (2)
- 07: TOP Is At Last Available (7)
June 2008 (1)
- 17: Operation CONNECT BY WITH FILTERING (12)
May 2008 (1)
- 31: Never Say Never (6)

EvoLve theme by Theme4Press • Powered by WordPress Striving for Optimal Performance