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

Ad: Der Oracle DBA – Handbuch für die Administration der Oracle Database 11gR2

14 October 2011 6 Comments Written by Christian Antognini

Der Oracle DBA

The book Der Oracle DBA (Hanser, 2011), which was written in German, is at last available!

I say “at last” because the authors worked on this project for not less than two years.

Who are the authors? Several colleagues of mine at Trivadis (Mirko Hotzy, Konrad Häfeli, Daniel Steiger, Sven Vetter, Peter Welker), Andrea Held, Lutz Fröhlich, Marek Adar and myself.

For my part, I wrote two chapters: Speicherplatzverwaltung and Optimierung.

11gR1, 11gR2
Impact of STATISTICS_LEVEL on Cardinality Feedback and Adaptive Cursor Sharing
Debugging PL/SQL and Java Stored Procedures with JPDA

6 Comments

  1. Flado Flado
    19 October 2011    

    I don’t know whether this is the right place to comment on the preview chapter of that book, but here goes:
    (P. 253, last sentence of 4.1.3.3)
    “Grundsätzlich muss die Datenbank gleich viel Memory besitzen, wie das Betriebssystem vor der Umstellung für den Buffer-cache verwendet hat.”
    Wouldn’t it be more accurate to say that the amount of memory for the database [instances] should be INCREASED by the amount used by the OS for filesystem buffering before the change? If not, why not?

    Gruß,
    Flado

    Reply
  2. Christian Antognini Christian Antognini
    19 October 2011    

    Hi Flado

    You are absolutely right! Unfortunately this is a mistake I was not able to spot… What happened is, that I wrote that chapter in English and only later on it was translated to German.

    Here the original and the published sentences:

    Original: To avoid such a problem you should increase the database buffer cache. Basically, you have to provide to the database engine the memory that was used by the operating system for the buffer cache.

    Published: Um dies zu verhindern, sollte der Datenbank Buffercache entsprechend groß sein. Grundsätzlich muss die Datenbank gleich viel Memory besitzen, wie das Betriebssystem vor der Umstellung für den Buffercache verwendet hat.

    Thank you for poiting out the mistake.

    Cheers,
    Chris

    Reply
  3. Flado Flado
    27 October 2011    

    Hi Chris,

    I found some time to read a couple of more pages of your chapter and it seems I stumble upon similar unclarities quite regularly. Knowing you, I’m sure all of them are due to the translation. Would it be possible for you to post the original (English) text of this chapter as well?

    Cheers,
    Flado

    Reply
    • Christian Antognini Christian Antognini
      27 October 2011    

      Hi Flado

      Sorry but I’m not allowed to share the text.

      Chris

      Reply
  4. Baku Baku
    4 November 2011    

    Could you tell me if it’s possible to buy this book in English?

    Reply
    • Christian Antognini Christian Antognini
      4 November 2011    

      Hi Baku

      Such a possibility doesn’t exist.

      Sorry,
      Chris

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.