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

7 Reply to “Papers/Presentations”

  1. Ron Whitby says:
    January 8, 2013 at 8:24 am

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

    Thanks

    Reply
    1. Tim Gorman says:
      March 3, 2013 at 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
      1. Sahil Soni says:
        February 3, 2014 at 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
        1. Tim Gorman says:
          February 3, 2014 at 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
  2. Prem says:
    November 27, 2017 at 8:02 pm

    Hi Tim & Team ,

    Could you please share a copy of below white paper with me ? Would be so helpful.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Re: Best practices for Datawarehouse: RAC or Non-RAC
    From: Tim Gorman
    To: ravigaur1@xxxxxxxxx
    Date: Wed, 17 Mar 2010 19:30:23 -0600

    Respectfully, I’d recommend reading “http://www.evdbt.com/TGorman%20TD2009%20DWScale.doc”;
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Thanks & Regards ,
    ~ JP ~

    Reply
    1. Tim Gorman says:
      November 28, 2017 at 8:50 am

      Prem,

      My apologies; this website has indeed changed substantially since 2010 and the URLs have changed, but the current version of both the paper and presentation available on the webpage above, listed “Scaling To Infinity: Partitioning Data Warehouses on Oracle Database”.

      Please let me know if you have any questions?

      Thanks!

      Reply
  3. Prem says:
    November 30, 2017 at 7:37 pm

    Thanks a lot for your quick reply .. Tim . That helps 🙂

    Reply

Leave a Reply to Tim Gorman Cancel reply

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

Time limit is exhausted. Please reload CAPTCHA.

About me

Recent Posts

  • 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
  • SQL Saturday 588 – May 20 in NYC April 30, 2017
  • SQL Saturday – 25-March 2017 – Colorado Springs CO March 18, 2017

Older posts…

Affiliations

© EvDBT 2021. Powered by WordPress