Skip to content

EvDBT

Evergreen Database Technologies, Inc.

Menu
  • About
  • Articles
  • Books
  • DBAKevlar
  • Papers/Presentations
  • Scripts
  • Videos

Papers/Presentations

Presentations

Icon

Presentation "Accelerating DevOps Using Data Virtualization"

1 file(s) 16.66 MB
Download
Click for full description

Icon

Presentation "Linux/UNIX Tools For The Oracle DBA"

1 file(s) 4.49 MB
Download
Click for full description

Icon

Presentation "How Oracle Data Recovery Mechanisms Complicate Data Security, And What To Do About It"

1 file(s) 1.37 MB
Download
Click for full description

Icon

Presentation "Avoiding The Pitfalls Of An Oracle E-Business Suites Upgrade"

1 file(s) 2.39 MB
Download
Click for full description

Icon

Presentation "Scaling To Infinity: Partitioning Data Warehouses On Oracle Database"

1 file(s) 4.68 MB
Download
Click for full description

Icon

Presentation "RDBMS Forensics - Troubleshooting Using ASH"

1 file(s) 2.69 MB
Download
Click for full description

Icon

Presentation "Three Types Of Table Compression"

1 file(s) 1.88 MB
Download
Click for full description

Icon

Presentation "Real-Time SQL Tuning" at Hotsos Sym2014 and UTOUG TD2014

1 file(s) 1.46 MB
Download
Click for full description

White Papers

Icon

Paper "Scaling To Infinity: Partitioning Data Warehouses On Oracle Database"

1 file(s) 370.58 KB
Download
Click for full description

Icon

Paper "RDBMS Forensics - Troubleshooting Using ASH"

1 file(s) 458.38 KB
Download
Click for full description

Icon

Paper "Three Types Of Table Compression"

1 file(s) 659.15 KB
Download
Click for full description

4 thoughts on “Papers/Presentations”

  1. Ron Whitby on January 8, 2013 | 8:24 am

    Can I get a copy of your paper “The Search for Intelligent Life in Oracle’s cost-based optimizer.

    Thanks

    Reply
    • Tim Gorman on March 3, 2013 | 3:48 pm

      Ron,
      My apologies for being so slow in reconstituting my website since migrating to WordPress. I will get everything re-posted for download soon, and I would be glad to share the white paper with you via email, with one huge caveat…

      …and that caveat is that the white paper was written for Oracle8.0 and Oracle8.1 only, and it has been effectively obsolete since Oracle9i, for almost 10 years now. So please bear in mind that using the OPTIMIZER_INDEX_CACHING and OPTIMIZER_INDEX_COST_ADJ parameters for any version of Oracle greater than Oracle8i is dangerous and will cause more problems than it resolves. Please consider using the GATHER_SYSTEM_STATS procedure within the DBMS_STATS package to set appropriate values within the SYS.AUX_STATS$ table for the CPU model of the cost-based optimizer. I strongly recommend reading up on gathering statistics using information posted by Maria Colgan at “http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/1354477.pdf” and Kimberly Floss at “http://www.oracle.com/technetwork/issue-archive/2005/05-jan/o15tech-tuning-090612.html”.

      If this is acceptable, then please let me know and I’ll send the white paper.

      Thanks!
      -Tim

      Reply
      • Sahil Soni on February 3, 2014 | 12:35 pm

        Hi Tim,

        Can you please send the “The Search for Intelligent Life in Oracle’s cost-based optimizer” whitepaper to my email address . Thanks in advance.

        Reply
        • Tim Gorman on February 3, 2014 | 2:16 pm

          Sahil,

          This white-paper is hopelessly obsolete; it was written for Oracle8i and has been largely obsolete since Oracle9i and the advent of the GATHER_SYSTEM_STATS procedure in the DBMS_STATS package.

          I strongly urge everybody *NOT* to play with the parameters OPTIMIZER_INDEX_CACHING and OPTIMIZER_INDEX_COST_ADJ, but rather to focus on gathering statistics properly to provide the cost-based optimizer all the information that it needs, because providing good cardinality estimates to the optimizer is much better than fiddling with parameters that severely skew the workings of a complicated mathematical engine. Gathering good statistics is not that hard; the default stats-gathering job created within the database since Oracle10g v10.1 accomplishes most of that, with a few small exceptions.

          I have kept this away off my website purposefully, for these reasons.

          Because I believe that I caused a significant amount of damage keeping that paper posted too long, I’m not going to post it again, or allow it to be posted anywhere, if I can. I still frequently see those two parameters in use, and I always recommend strongly to cease doing so. Where ever I find that paper re-posted, I always have (and always will) request that it be taken down.

          If you really want me to share this ancient white paper with you, then I’ll email it to you, as long as you promise never to use those two parameters (i.e. OPTIMIZER_INDEX_*) for anything other than testing?

          Thanks!

          -Tim

          Reply

Leave a Reply Cancel reply

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

Time limit is exhausted. Please reload CAPTCHA.

About me

Recent Posts

  • Azure host-caching with Oracle database workloads on Azure VMs July 2, 2021
  • Oracle dNFS on NFS v4.1 June 17, 2021
  • Delphix XPP explained November 14, 2019
  • Oak Table World 2018 October 25, 2018
  • Achieving a balance December 1, 2017
  • Automating Stored Procedures When Refreshing Virtual SQL Server Databases October 31, 2017

Older posts…

Affiliations

EvDBT 2025 . Powered by WordPress