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.
Advanced Diagnostics Revisited
|
This presentation discusses some of the new diagnostics features that have appeared in recent (11gR2 and above) versions of Oracle. It is not an exclusive list, but I have tried to select the features that I believe are the most interesting / useful. There is a small amount of common material with the original Advanced Diagnostics presentation, mainly to give context, but the majority of the features covered are new. The presentation was given at the UKOUG Conference in December 2014. The presentation was developed against Oracle 11.2.0.3, 11.2.0.4, 12.1.0.1 and 12.1.0.2
|
|
Oracle 12c New Features
|
This presentation discusses some of the new features included in Oracle 12c that may be of interest to DBAs. The presentation was given at the UKOUG Conference in December 2013. The presentation was developed in Oracle 12.1.0.1
|
|
Understanding GoldenGate
|
This presentation contains an introduction to Oracle GoldenGate. It was first presented at the UKOUG AIM SIG in 2013.
|
|
Is RAT Worth Catching?
|
This presentation discusses the advantages and disadvantages of Oracle Real Application Testing (RAT) as implemented in Oracle 11g Release 2. The presentation was given at the UKOUG Conference in 2012. The presentation was developed in Oracle 11.2.0.3
|
|
Dissecting RAT
|
This presentation discusses the information contained within the internal structures used Oracle Real Application Testing including record files and workload metadata files. This presentation was developed for Oak Table Sunday at the UKOUG Conference in 2012. The presentation was developed in Oracle 11.2.0.3
|
|
Optimizer Statistics
|
This presentation discusses the collection and use of optimizer statistics. The presentation was given at the UKOUG Northern Server Technology SIG in 2009, the UKOUG Conference 2009 and the Scottish DBA SIG in 2010
|
|
Edition-Based Redefinition
|
This presentation introduces Edition-Based Redefinition. It is based on material from the Oracle 11gR2 for RAC Users seminar
|
|
Real Application Testing
|
This presentation introduces Real Applcation Testing. It is based on material from the Oracle 11gR2 for RAC Users seminar.
|
|
Configuring Advanced Replication
|
This web presentation describes a basic Advanced Replication multi-master configuration. The presentation was developed in Oracle 10.2.0.4
|
|
RAC Basics
|
This presentation contains an introduction to RAC. It was presented at UKOUG Back to Basics event in February 2008.
|
|
Data Guard Basics
|
This presentation contains an introduction to Data Guard. It was presented at UKOUG Back to Basics event in February 2008.
|
|
Automatic Storage Management
|
This presentation describes some of the internal functionality of Automatic Storage Managemment. The presentation includes descriptions of extent distribution and rebalancing behaviour. It was presented at UKOUG Conference in December 2008.
|
|
LOB Internals
|
This presentation describes the implementation of LOBs with particular emphasis on the LOB locator. The presentation mainly covers Basic Files. It also briefly looks at Secure Files in Oracle 11.1 which offer greatly improved compression functionality which may justify the additional licence cost for some users. It was presented at UKOUG Conference in December 2008.
|
|
Advanced Queuing Internals
|
This presentation describes the implementation of Advanced Queuing highlighting the performance implications of various configuration decisions. It was presented at OUG Scotland Conference in October 2008 and at the UKOUG DBMS SIG in November 2008
|
|
Flashback Logging Internals
|
This presentation describes the implementation of Flashback Logging. It was presented at the Miracle Scotland Conference in June 2007, Slovenian Oracle User Group (SIOUG) Conference in September 2007, UKOUG Unix SIG in September 2007, OUG Scotland Conference in October 2007, and at the UKOUG Conference 2007 |
|
Result Cache Internals
|
This presentation describes the implementation of the server-side Result Cache in Oracle 11.1 and above. It was presented as part of "Investigating Oracle" at the Slovenian Oracle User Group (SIOUG) Conference in September 2007, UKOUG DBMS SIG in November 2007 and at the UKOUG Conference 2007
|
|
Oracle VM
|
This presentation describes the installation and configuration of Oracle VM. It was presented at UKOUG Application Server and Middleware SIG in October 2008
|
|
RAC Troubleshooting
|
This presentation describes various RAC troubleshooting tools including trace and diagnostics. It was presented at ORCAN (Swedish OUG) Conference in June 2008. For more recent information see the latest version of my 2-day seminar.
|
|
RAC Performance Tuning
|
This presentation contains a very limited look at RAC performance tuning. It was presented at ORCAN (Swedish OUG) Conference in June 2008. For more recent information see the latest version of my 2-day seminar.
|
|
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 Tex
as. 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 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.
|
|