Written by 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 |
Christian, Thanks