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