Oracle Internals
JulianDyke.com

Welcome

Consultancy

Seminars

Blog

Presentations

Diagnostics

Internals

 

Presentations

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 (NEW)
Oracle 12c New Features
Understanding GoldenGate
Is RAT Worth Catching?
Dissecting RAT
Optimizer Statistics 
Optimizer Statistics 
Edition-Based Redefinition 
Real Application Testing 
Configuring Advanced Replication
RAC Basics
Data Guard Basics
Automatic Storage Management
LOB Internals
Advanced Queuing Internals
Flashback Logging Internals
Result Cache Internals
Oracle VM
RAC Troubleshooting
RAC Performance Tuning
Inside RAC
A Rough Guide to RAC
RAC On Windows 2003
Oracle Diagnostics
Forgotten Features
Reducing Redo
Logical I/O

Transaction Internals
SGA Internals

Library Cache Internals
Redo Internals
Index Internals
Bitmap Index Internals

IOT Internals
RAC Internals

Oracle 10.2 New Features
Oracle 10.2 RAC New Features

Oracle 10.2 ASM New Features
Supplemental Logging
Streams
Logical Standby
Data Segment Compression
Native PL/SQL Compilation



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 commom 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.

Oracle 10.2 RAC New Features

This presentation describes a handful of new RAC features in Oracle 10g Release 2.

Oracle 10.2 ASM New Features

This presentation describes a couple of new ASM features in Oracle 10g Release 2.

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.