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

24 June 2010 7 Comments Written by Christian Antognini

This is just a short note to point out that I just uploaded a new version of the scripts related to TOP. The new ZIP is available through this page.

The change log is the following:

connect.sql Added DBM10205, DBA10205, DBM11201 and DBA11201
chapter02bind_variables.sql Because of 11g modified/added queries against V$SQL_SHARED_CURSOR
chapter02sharable_cursors.sql Added SET SERVEROUTPUT OFF in the initialization part
chapter03dbms_hprof.sql New file
chapter03sql_trace_trigger.sql New file
chapter06display_awr.sql Improved query that displays AWR content
chapter06execution_plans.sql Added example for UNION ALL (RECURSIVE WITH)
chapter07baseline_evolution_delete.sql New file
chapter07baseline_upgrade_11g.sql After import added update to set the owner of the SQL tuning set
chapter07opt_estimate.sql Uncommented 11g query
chapter07outline_with_hj.sql Script compatible with 10g/11g (set “_hash_join_enabled”)
chapter07tune_last_statement.sql Added SET SERVEROUTPUT OFF in the initialization part
chapter08client-side_caching.sql New file
chapter09conditions.sql Added queries containing NOT IN condition
chapter09hash_cluster.sql Changed comment related to IN operator because of 11.2 improvement
chapter10hash_join.sql Fixed typo in description
chapter10join_elimination.sql Fixed typo in description
chapter10join_elimination2.sql New file
chapter10pwj.sql Disabled join-filter pruning
chapter10subquery_unnesting.sql Cover many more cases
chapter11ArrayInterface.java Added check for the return value of the executeBatch method
chapter11ArrayInterfacePerf.java Fixed number of iterations in main method
chapter11atomic_refresh.sql Changed CTAS to avoid ORA-30009
chapter11dpi_performance.sql Changed CTAS to avoid ORA-30009
chapter11px_auto_dop.sql New file
chapter11px_ddl.sql Changed the part displaying the parallel DDL status
chapter11px_dml.sql Changed the part displaying the parallel DML status
chapter11px_query.sql Changed the part displaying the parallel query status
chapter11result_cache_plsql.sql Added comment about invalidation in 11.2
chapter12data_compression.sql Changed CTAS to avoid ORA-30009
databasesDBA10205 New directory containing the files to create the database DBA10205
databasesDBM10205 New directory containing the files to create the database DBM10205
databasesDBA11201 New directory containing the files to create the database DBA11201
databasesDBM11201 New directory containing the files to create the database DBM11201
TOP
Related-Combine Operation „UNION ALL (RECURSIVE WITH)“
Oracle OpenWorld Schedule

7 Comments

  1. Yasir Hashmi Yasir Hashmi
    7 October 2010    

    Sir,
    The zip file doesn’t contain the table creation scripts that you have used in demos. Kindly provide that also.

    Reply
    • Christian Antognini Christian Antognini
      7 October 2010    

      Hi

      Mhmm… almost every script creates the tables it needs… With which demo do you have problems?

      Cheers,
      Chris

      Reply
  2. Yasir Hashmi Yasir Hashmi
    7 October 2010    

    Sir,
    I am talking about t1,t2,… tables.I couldn’t find them.

    Many thanks

    Reply
  3. Christian Antognini Christian Antognini
    7 October 2010    

    Hi

    IIRC the only scripts that do not create t1, t2, … are the ones of chapter 10. In fact, those scripts call the script create_tx.sql for that purpose. If they are not automatically created when you run a script it probably means that your current directory is not the onewhere the scripts are stored.

    HTH
    Chris

    Reply
  4. Yasir Hashmi Yasir Hashmi
    8 October 2010    

    Sir,
    Thanks for the reply.I found them in the folders.
    BTW,when are you planning to write a book on instance tuning? Or it would have been wonderfull if the TOP had a section for instance tuning also.That certainly would have completed the meaning of TOP.

    Reply
    • Christian Antognini Christian Antognini
      11 October 2010    

      Hi

      > BTW,when are you planning to write a book on instance tuning?

      I do not plan to write another book. The only thing I can think of, is to provide a second edition of TOP….

      > Or it would have been wonderfull if the TOP had a section for instance tuning also.

      I basically agree with you. But, since time is restricted, I had to make a choice. And, honestly, instance tuning is irrelevant in most situations with the current releases. In fact, most of the time I see customers struggling with either poor hardware performance or applications-related issues.

      Cheers,
      Chris

      Reply
  5. Yasir Hashmi Yasir Hashmi
    11 October 2010    

    Sir,
    You are absolutely correct. Oracle has automated so many things like ASMM etc that there is no need to worry about sizing memory structures.But at times we do get contentions in shared memory,lock issues,Buffer cache contentions etc.Since you got an amazing talent to write and explain things,it would be a great help to the oracle community if you could enlighten the subject.

    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.