I have added this page in response to requests that I receive regularly for copies of old presentations. Please note that the presentations available on this page are not necessarily the same as the originals as I have modified most of them following feedback from live audiences. Note also that I adjust the length of live presentations by adding or deleting slides therefore the number and order of slides may differ from previous versions.
If you have difficulty downloading or reading any of these presentations please contact me.
|
Inside RAC
|
|
This presentation describes some of the internal mechanisms which differentiate RAC databases from single-instance databases. The presentation provides a basic introduction to memory structures. It examines the buffer cache and how Global Cache Services (GCS) maintains buffer cache consistency across multiple instances. It then examines the library cache and how Global Enqueue Services (GES) maintains locks across multiple instances. It was presented at the Hotsos Symposium 2006 in Dallas Texas. A version was also presented as a webcast for the International RAC SIG in April 2006.
|
|
|
A Rough Guide to RAC
|
|
This is intended to be a gentle introduction to RAC for non-RAC users. It was presented at the Scottish Oracle User Group in Glasgow during October 2005.
|
|
|
RAC On Windows 2003
|
|
This presentation attempts to fill in some of the gaps in the Oracle RAC on Windows documentation. It is intended to supplement rather than replace the documentation and to provide some insights into the concepts and issues faced when deploying on Windows 2003.
|
|
|
Oracle Diagnostics
|
|
This presentation describes various diagnostic features in Oracle. Much of the Diagnostics section of this site is based on this presentation. I have presented this content on numerous occasions including UKOUG Conference 2002 in Birmingham, Hotsos Symposium 2003 in Dallas, Texas, UKOUG Irish Technology SIG in Dublin during February 2003, the Miracle Database Forum in Denmark during October 2004 and the UKOUG DBMS SIG in Warwick UK during December 2004.
|
|
|
Forgotten Features
|
|
This presentation discusses a large number of features that are included in the Oracle database, but are frequently overlooked by both the marketing department and end-users. It was presented at the Oracle User Group Finland (OUGF) Conference in Tallinn, Estonia during May 2005, at the UKOUG DBMS SIG in London during July 2005 and will be repeated again at the UKOUG Conference 2005 in Birmingham during November 2005.
|
|
|
Reducing Redo
|
|
This presentation discusses techniques for reducing the amount of redo an application generates. It was presented at the Slovenian Oracle User Group (SIOUG) Conference in Portoroz, Slovenia during September 2005 and will be repeated at the UKOUG Conference 2005 in Birmingham during November 2005.
|
|
|
Logical I/O
|
|
This presentation discusses various types of logical I/O. It includes some examples which demonstrate the buffer cache algorithm in Oracle 9.2. It is based on "All Logical I/Os Are Equal, But Some Are More Equal Than Others" which I presented at the UKOUG Conference 2004 in Birmingham. I also repeated part of this presentation at the Oracle User Group Finland (OUGF) Conference in Tallinn, Estonia during May 2005
|
|
|
Transaction Internals
|
|
This presentation describes the internal mechanisms provided in Oracle to support transactions, including undo and read-consistency. It also examines new undo-based features such as flashback and row dependenies. It is based on "Further Inside RAC" which I presented at the Hotsos Symposium 2007 in Dallas.
|
|
|
SGA Internals
|
|
This presentation describes the internal SGA structures of a single-instance Oracle 9.2 database including areas, granules, heaps, subheaps, caches and execution plans and redo buffers. It is based on "Voyage to the Bottom of the SGA" which I presented at the UKOUG Conference 2004 in Birmingham. I also repeated part of this presentation at the Oracle User Group Finland (OUGF) Conference in Tallinn, Estonia during May 2005
|
|
|
Library Cache Internals
|
|
This presentation outlines the structure of the library cache and then describes some of the causes of multiple parent cursors and multiple child cursors within the library cache. It is based on "Finding the Trash in your Library Cache" which I presented at the Scottish OUG Conference in September 2006 and anticipate presenting a revised version at the UKOUG Conference in November 2006.
|
|
|
Redo Internals
|
|
This presentation describes the internal structure of the online redo log. I presented this at the UKOUG DBMS SIG in London during July 2003.
|
|
|
Index Internals
|
|
This presentation describes the internal structure and behaviour of B-tree indexes. It is based on "Index Internals I" which I presented at the UKOUG Conference 2002 in Birmingham.
|
|
|
Bitmap Index Internals
|
|
This presentation describes the internal structure of bitmap indexes. I originally presented this at the Miracle Database Forum in Denmark during October 2003 and again at the UKOUG DBMS SIG in November 2003.
|
|
|
IOT Internals
|
|
This presentation describes the internal structure of Index Organized Tables (IOTs). It is based on "Index Internals II" which I presented at the UKOUG Conference 2003 in Birmingham.
|
|
|
RAC Internals
|
|
This presentation describes how the read-consistency mechanism is implemented in a RAC environment. It is based on "Further Inside RAC" which I presented at the Hotsos Symposium 2007 in Dallas. When time allows, this presentation will be extended to include additional information on both read-consistency and other RAC internal mechanisms.
|
|
|
Oracle 10.2 New Features
|
|
This presentation describes a number of new features in Oracle 10g Release 2. Parts were initially presented at the Slovenian Oracle User Group (SIOUG) Conference in Portoroz, Slovenia during September 2005 and the UKOUG UNIX SIG in Slough, England also during September 2005.
|
|
|
|
|
|
|
Supplemental Logging
|
|
This presentation describes supplemental logging as implemented in Oracle 10.2.0.1. The contents of this presentation is a pre-requisite for both the Streams and Logical Standby presentations also available on this page. This material was presented as part of "Logical Standby versus Streams" at the UKOUG UNIX SIG in September 2006.
|
|
|
Streams
|
|
This presentation describes how I implemented a Streams test environment in Oracle 10.2.0.1. It also describes how to manually create Logical Change Records (LCRs). Some complementary material can be found in the "Supplemental Logging" presentation on this page. This material was presented as part of "Logical Standby versus Streams" at the UKOUG UNIX SIG in September 2006.
|
|
|
Logical Standby
|
|
This presentation describes how I implemented a Logical Standby test environment based on a physical standby database in Oracle 10.2.0.1. Some complementary material can be found in the "Supplemental Logging" presentation on this page. This material was presented as part of "Logical Standby versus Streams" at the UKOUG UNIX SIG in September 2006.
|
|
|
Data Segment Compression
|
|
This presentation was prepared when Data Segment Compression was introduced in Oracle 9.2.0.1 as there was little explanatory documentation or research available at the time about this powerful feature. Some of the functionality has been subsequently updated by Oracle, but the presentation has not yet been updated to reflect this. This material was presented to the UKOUG Unix SIG in January 2003.
|
|
|
Native PL/SQL Compilation
|
|
This short presentation describes the Native PL/SQL Compilation feature introduced in Oracle 9.0.1 and enhanced in Oracle 10.1.
|
|
