| Filename | Author |
Date |
Comments | Downloads |
|---|
| RAC_Sequences.pdf |
Joel |
2008-06-06 |
Slides from Usergroup presentation on RAC Sequence management. |
673 |
| 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. |
518 |
| 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. |
770 |
| Riyaj_tool_Techniques_for_ unix_DOUG_2007.zip |
Riyaj Shamsudeen |
2008-03-21 |
Various unix tools and techniques for advanced debugging, DOUG 2006 presentation |
1029 |
| 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 |
671 |
| 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 |
535 |
| 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 |
485 |
| 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. |
601 |
| 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. |
625 |
| Bobak_Hotsos_2006.zip |
Mark Bobak |
2007-09-13 |
Understanding and Interpreting Deadlocks
Presented at Hotsos 2006. |
1313 |
| slb.tar.gz |
Kevin Closson |
2007-09-04 |
A tar archive of the Silly Little Benchmark (memory hammer) |
1223 |
| 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. |
3608 |
| 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. :) |
2875 |
| 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. |
2402 |
| 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 |
3068 |
| 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 |
4090 |
| 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
|
3593 |
| 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 |
5134 |
| 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 |
4060 |
| 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 |
2915 |
| 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 |
5634 |
| SAN Stories_.pdf |
Anjo Kolk |
2005-11-01 |
"SAN stories" by Anjo Kolk, Symantec
Presentation from OakTable day at UKOUG 2005 |
4957 |
| 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 |
2433 |
| Row Versioning.pdf |
Peter Gram |
2005-11-01 |
"Row versioning" by Peter Gram, Miracle A/S
Presentation from OakTable day at UKOUG 2005 |
2177 |
| 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.
|
4849 |
| 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. |
8030 |
| 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. |
10309 |
| 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. |
8895 |
| 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 |
8576 |
| Kratvej-Demo-Rave.avi |
James Morle |
2002-11-12 |
The famous Kratvej rave video, shot by Michael Moller! |
6212 |
| 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! |
6702 |
| 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? |
4976 |
| 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. |
6155 |
| dbstat.sql |
Connor McDonald |
2002-10-10 |
A simple script for enchancing the functionality of dbms_stats to gather optimizer statistics. |
5286 |
| 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 |
3751 |
