Striving for Optimal Performance
  • Blog
    • Archive
    • Categories
    • Search
  • Troubleshooting Oracle Performance
    • Description
    • Structure
    • Table of Contents
    • Forewords
    • Reviews
    • Downloadable Files
    • Addenda and Errata
    • First Edition
  • Public Appearances
    • Past Public Appearances
  • Contact
  • About

TVD$XTAT 4.0 Beta 11

1 March 2017 Written by Christian Antognini

This is just a short note to point out that I finally uploaded a new version of TVD$XTAT. To download it click here. Not only I introduced some new features, but I also fixed several bugs. The detailed change log since Beta 10 is the following: Added support for bind sets using array processing Added […]

Read More 3 Comments

Auto SGA Management Impacts the Default Value of DB_FILE_MULTIBLOCK_READ_COUNT

10 October 2015 Written by Christian Antognini

The database engine determines the maximum disk I/O size used during multiblock reads (for example, full table scans or index fast full scans) by multiplying the values of the db_block_size and db_file_multiblock_read_count initialization parameters. The db_file_multiblock_read_count initialization parameter can be set explicitly, or, as of version 10.2, it’s also possible to instruct the database engine […]

Read More 6 Comments

UKOUG TECH14 SQL Quiz

4 December 2014 Written by Christian Antognini

If you are an attendee of UKOUG Tech14 you have a chance to win a free copy of Expert Oracle SQL by Tony Hasler AND a free copy of Troubleshooting Oracle Performance (2nd edition) by myself. If you want to know more, click here.

Read More Leave a Comment

Differences between the First and the Second Edition of Troubleshooting Oracle Performa...

5 June 2014 Written by Christian Antognini

Several people asked me how much I changed in the second edition. The short answer is… A LOT. The main goals set for the revision of the book were the following: Add content about Oracle Database 11g Release 2 and Oracle Database 12c Release 1. Remove content about Oracle9i and Oracle Database 10g Release 1. […]

Read More 5 Comments

Troubleshooting Oracle Performance, 2nd Edition

1 June 2014 Written by Christian Antognini

Few days ago the second edition of Troubleshooting Oracle Performance was finally published. Today, I updated the pages on this site that provide information about the book. It goes without saying that the new pages cover the second edition. Hence, from here you can access the description, the table of contents, the forewords written by […]

Read More 5 Comments

Premature Optimization

14 March 2013 Written by Christian Antognini

Premature optimization, (probably) because of Donald Knuth’s famous line “premature optimization is the root of all evil,” (see Structured Programming with go to Statements) is, at the very least, a controversial topic. The misconception based on that particular quote is that a programmer, while writing code, should ignore optimization altogether. In my opinion this is […]

Read More 7 Comments

Index Scan with Filter Predicate Based on a Subquery

6 February 2012 Written by Christian Antognini

Most execution plans can be interpreted by following few basic rules (in TOP, Chapter 6, I provide such a list of rules). Nevertheless, there are some special cases. One of them is when an index scan, in addition to the access predicate, has a filter predicate applying a subquery. The following execution plan, taken from […]

Read More 4 Comments

Ad: The Oracle Query Optimizer 2-Day Seminar

18 December 2011 Written by Christian Antognini

The 31st of January and 1st of February 2012 I will present a 2-day seminar about the Oracle query optimizer in Ballerup (DK). The event is organized by Miracle A/S. The content, which is based on the chapters 2, 4, 5, 6, 9 and 10 of my book, is the following: Chapter 1 describes the […]

Read More Leave a Comment

optimizer_secure_view_merging and VPD

11 September 2011 Written by Christian Antognini

At page 189 of TOP I wrote the following piece of text: In summary, with the initialization parameter optimizer_secure_view_merging set to TRUE, the query optimizer checks whether view merging could lead to security issues. If this is the case, no view merging will be performed, and performance could be suboptimal as a result. For this […]

Read More 12 Comments

Ad: DOAG Berliner Expertenseminare (Last Call)

23 May 2011 Written by Christian Antognini

I was just informed that there are still some free seats for the 2-day seminar I will present in Berlin in two weeks (June 7-8). Hence, do not wait too long if you want to join us… The content is based on the chapters 4, 5, 6 and 7 of my book, i.e. part 3: […]

Read More 4 Comments
Older Entries