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

Troubleshooting Oracle Performance – Downloadable Files

8 March 2009 1 Comment Written by Christian Antognini

I just uploaded a new version of the scripts related to my book, Troubleshooting Oracle Performance. If you are among one of the about 1500 persons that downloaded the initial release, I suggest you to download the new one through this page.

The change log is the following:

connect.sql Added DBM11107 and DBA11107
chapter02/bind_variables.sql Fixed typo in comment
chapter02/sharable_cursors.sql Added note about sharable_cursors_9i.sql + Fixed comment
chapter02/sharable_cursors_9i.sql New file
chapter03/map_session_to_tracefile.sql As of 11g the function LOWER must not be applied to the instance name
chapter04/col_usage.sql New file
chapter04/comparing_object_statistics.sql Fixed timing issue after sleep + ORA-00001
chapter05/bug5015557.sql Fixed hints + Added note about supported database releases
chapter05/dynamic_sampling_levels.sql Fixed typo in header
chapter05/optimizer_secure_view_merging.sql Added service to CONNECT statements + Changed notes in header
chapter06/explain_plan.sql Fixed wrong CTAS in “Setup test environment”
chapter07/baseline_autoevolution.sql New file
chapter07/all_rows.sql Added query to show SQL profile in 11g
chapter08/ParsingTest1.cs New file
chapter08/ParsingTest2.cs New file
chapter09/hash_cluster.sql New file
chapter10/merge_join.sql Added hint gather_plan_statistics to the last three queries
chapter11/ArrayInterface.cs New file
chapter11/RowPrefetching.cs New file
databases/DBA11107 New directory containing the files to create the database DBA11107
databases/DBM11107 New directory containing the files to create the database DBM11107
TOP
Virtual Column-Based Partitioning Might Lead to Wrong Results
SQL and Relational Theory

1 Comment

  1. Bundit Bundit
    17 March 2009    

    Christian, Thanks

    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.