Login | About Us | Join | Contact
Search

The requested file was not found. Please locate the requested file in the list of currently available files below

Contributed Files

This page contains uploaded whitepapers and files from members of the OakTable. The copyright of all files in the section remains with the respective author, as indicated below, and this should be respected: Please email the author if you are interested in using their work for anything other than personal interest.
FilenameAuthor Date CommentsDownloads
RAC_Sequences.pdf Joel 2008-06-06 Slides from Usergroup presentation on RAC Sequence management. 302
rac_sequences.sql Joel 2008-06-06 Demo of sequences Management in RAC including SQ En queues, SV Instance Locks, Cached Sequence management, and Gap management. 253
riyaj_tunng_with_sql_new_features_9i_10g_RMOUG2008.zip Riyaj Shamsudeen 2008-03-21 How to use model, analytic functions etc for tuning? Introduces concepts, explains and shows how performance is improved. 494
Riyaj_tool_Techniques_for_ unix_DOUG_2007.zip Riyaj Shamsudeen 2008-03-21 Various unix tools and techniques for advanced debugging, DOUG 2006 presentation 501
Riyaj_redo_internals_ppt_UKOUG_2006.zip Riyaj Shamsudeen 2008-03-21 Discuss internals of redo records, concepts and how to tune by redo reduction 429
Riyaj_exciting_sql_new_features_DOUG_2006_.zip Riyaj Shamsudeen 2008-03-21 Introduces various sql new features such as subquery factoring, model, analytic functions etc. Presented in DOUG 2006 327
Riyaj_exciting_sql_new_features_DOUG_2006.zip Riyaj Shamsudeen 2008-03-21 Introduces various sql new features such as subquery factoring, model, analytic functions etc. Presented in DOUG 2006 283
Riyaj_debunking_myths_riyaj_UKOUG2007.zip Riyaj Shamsudeen 2008-03-21 Debunking various myths and misconceptions about redo, undo, commit and rollback. Scripts provided. Audience: Experienced. Presented in various conferences such as UKOUG, SIOUG etc. 374
Riyaj_Advanced_index_internals_DOUG_2005.zip Riyaj Shamsudeen 2008-03-21 Review various index structures, internals of indices and explains how they can be effectievely used. Presented DOUG 2005. 390
Bobak_Hotsos_2006.zip Mark Bobak 2007-09-13 Understanding and Interpreting Deadlocks
Presented at Hotsos 2006.		 1018
slb.tar.gz Kevin Closson 2007-09-04 A tar archive of the Silly Little Benchmark (memory hammer) 973
scripts_.zip Joel 2006-04-06 THis is a zip file containing the up to date list of demos that i use for mentoring or training in Oracle DBA technology. It replaces the previous file which was uploaded a while ago. 3386
dbms_powernap.zip Pete Sharman 2006-03-11 The introduction of a new package in the 10i beta timeframe, DBMS_POWERNAP. Extract to c:\temp, open the html file, turn the sound up and wait for the SQL to execute. :) 2703
design_pef_scale.html Bjørn Engsig 2006-02-03 This white paper discusses how applications can be properly designed to ensure application performance and scalability. The paper covers topics like bind variables, cursors, and SQL exeuction and is an extension to my previous paper on the same topic. Additionally, guidelines are included for popular APIs like OCI, PL/SQL and ODBC. 2177
Microsoft Word - Jeff Needham Adding a Node to 10gR1 on RHEL4_.pdf Kirstine Bjerre Bergholdt 2005-12-15 Read the article by Jeff Needham: "Adding a Node to 10gR1 on RHEL4 2809
Tuning by CF.pdf holm 2005-11-14 "Tuning by Cardinality Feedback - Method with Example" by Wolfgang Breitling

Presentation from OakTable Day at UKOUG 2005		 3812
SQLnet Message idle time or your issue.pdf holm 2005-11-14 "SQL*Net Message (idle time or your issue)" by Gary Goodman, Hotsos

Presentation from OakTable Day at UKOUG 2005
3324
RMAN Internals and History.pdf Tuomas Pystynen 2005-11-10 "RMAN Internals & History" by Tuomas Pystynen, Deepbase Consulting Oy

Presentation from OakTable Day at UKOUG 2005		 4740
A Brief History of DB Time__.pdf Graham Wood 2005-11-10 "A Brief History of DB Time" by Graham Wood, Oracle

Presentation from OakTable Day at UKOUG 2005		 3753
Linux in the Enterprise.pdf James Morle 2005-11-10 "Linux in the Enterprise" by James Morle Scale abilities

Presentation from OakTable Day at UKOUG 2005		 2698
What Larry should have told Bill many years_.pdf Peter Gram 2005-11-01 "What Larry should have told Bill many years ago" by Erling Skaale, Miracle A/S

Presentation from OakTable day at UKOUG 2005		 5323
SAN Stories_.pdf Anjo Kolk 2005-11-01 "SAN stories" by Anjo Kolk, Symantec

Presentation from OakTable day at UKOUG 2005		 4579
FlatTree.pdf Michael Möller 2005-11-01 "How to flatten a tree with Materialized Views" by Michael A. G. Möller, Miracle A/S

Presentation from OakTable day at UKOUG 2005		 2220
Row Versioning.pdf Peter Gram 2005-11-01 "Row versioning" by Peter Gram, Miracle A/S

Presentation from OakTable day at UKOUG 2005		 1963
CBO_Stats.pdf Peter Bach 2005-03-07 This paper looks at some of the questions and challenges you need to consider when you are planning statistics collection for Oracle's Cost Based Optimizer. This investigation is based on Oracle RDBMS release 9.2.0.3 and 9.2.0.5 running on HP-UX and RDBMS 10.0.1.2 running on XP professional.
4615
owcph2002_engsig_cursor_paper.pdf Bjørn Engsig 2003-12-11 Ever had problems with latch contention for the library cache latch or the shared pool latch? Bets are that your application could be coded better, og that you could turn on a few init.ora parameters, that may increase your database performance. If you would like some understanding of what is going on, and how you should or should not code your application, take a look at this paper. The paper was presented at Oracle World in Copenhagen and discusses things like parsing and executing cursors, bind variables, etc. 7777
owcph2002_engsig_statspack_paper.pdf Bjørn Engsig 2003-12-11 Although Cary Millsap rightfully says you should go straight to the core and turn on 10046 tracing, there are still lots of people out there, who run statspack and would like to get something out of all these reports. This paper will take you straight to the few figures containing information - passing all the meaningless data - in your statspack report. The version available here is from my presentation at Oracle World in Copenhagen 2002. 10035
BrewingBenchmarks.pdf James Morle 2003-12-04 How to produce accurate Oracle benchmarks using only trace files. Very little time is required to produce a fully working benchmark of *your* application using the techniques and software presented in this paper. Presented at the UKOUG Conference 2003. 8589
Miracle_3_RAC9i_W2k.pdf Bjørn Engsig 2003-01-25 Hints and tips for a succesful installation of RAC on a Windows/2000 clusterm 8162
Kratvej-Demo-Rave.avi James Morle 2002-11-12 The famous Kratvej rave video, shot by Michael Moller! 6053
Unbreakable.pdf James Morle 2002-10-22 There's no doubt that RAC is a huge leap forward over Parallel Server. Is it really now the case that virtually linear intra-node scaling can be obtained with little thought to the application? Includes Papa's Secret Laptop RAC Recipe! 6413
The New Rules of Deployment.pdf James Morle 2002-10-22 Solid-State disks have been an intriguing possibility in Oracle-based systems since their inception. However, a lot has changed since they first hit the streets, not least SANs, cached disk arrays and large memory support. So where do SSDs sit in the new order of I/O hierarchy? 4738
Sane_SAN_WP.pdf James Morle 2002-10-22 In a world of SAN-based insanity, seek refuge in a few logical thoughts on how to regain predictable, measured performance, and simple maintenance of your SAN. 5881
dbstat.sql Connor McDonald 2002-10-10 A simple script for enchancing the functionality of dbms_stats to gather optimizer statistics. 5054
ascii.sh Kyle Hailey 2002-09-12 translate hex into ascii.

$ ascii.sh 5458
T X

ie in HEX, the string "TX" is 5458

like wise you can pipe an Oracle Trace file with HEX dumps in it and get some interesting output
$ cat ora_88008.trc | ascii.sh

How do you translate an Oracle Trace file hex dump back into ascii? Or how do you translate a wait event P1 value into the lock type? I never found a utility that took an ascii representation of a hex representation of ascii and turned it back into ascii. This all sound very confusing in writing but the example above shows it in action		 3526
Copyright © 2002 The OakTable Network

Sessions: Current=796 Since boot=46207 Peak=1374