Striving for Optimal Performance

Archives

Here you find a list of all my posts:

March 2010 (1)
- 08: Inserts Experiencing an Increasing CPU Consumption (4)
February 2010 (1)
- 28: Tracing VPD Predicates (0)
January 2010 (4)
- 31: The Art of Application Performance Testing (1)
- 26: Does the Query Optimizer Cost PX Distribution Methods? (11)
- 12: Edition-Based Redefinition (6)
- 11: Join Elimination (11)
December 2009 (2)
- 18: Chinese Edition of TOP Available! (3)
- 17: Does CREATE INDEX Gather Global Statistics? (2)
November 2009 (2)
- 29: Instance Caging (4)
- 25: Zero-Size Unusable Indexes and the Query Optimizer (9)
October 2009 (2)
- 23: Hints for Direct-path Insert Statements (11)
- 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 (16)
August 2009 (4)
- 19: Synthetic Commits and Rollbacks (3)
- 16: Upcoming Speaking Engagements (2)
- 12: System Managed Extent Size – 11g Improvements (12)
- 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 (23)
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 (8)
- 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 (6)
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 (3)
- 05: PerformaSure X-Agent Configuration (3)
December 2008 (3)
- 22: What Are Hints?
- 10: Automatic Evolution of SQL Plan Baselines (8)
- 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 (3)
- 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 (3)
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 (7)
May 2008 (1)
- 31: Never Say Never (6)