This event has ended

Jonathan Lewis - All new 2-day "Oracle Structures" webinar

Speak-Tech Webinars

Monday, February 3, 2014 at 9:00 AM - Tuesday, February 4, 2014 at 4:00 PM (CST)

Jonathan Lewis - All new 2-day "Oracle Structures" webinar

Registration Information

Registration Type Sales End Price Fee Quantity
Oracle Structures Webinar   more info Ended $600.00 $0.00
Webinar + Oracle Mechanisms webinar recording   more info Ended $800.00 $0.00
Webinar + Indexing Strategies webinar recording   more info Ended $700.00 $0.00
Webinar + both webinar recordings   more info Ended $900.00 $0.00

Who's Going

Loading your connections...

Share Jonathan Lewis - All new 2-day "Oracle Structures" webinar

Event Details

Jonathan Lewis is one of the world's foremost Oracle performance experts; an Oracle ACE Director and a member of the prestigious Oak Table Network, a network for top Oracle Scientists.

Jonathan has long been a top presenter at IOUG, Oracle OpenWorld, UK Oracle User Group, and at User Groups everywhere. His very popular "Oracle Scratchpad" is an excellent starting point for all things Oracle.

The cost of two days of world-class training by Jonathan is $600 and this includes your choice of (once payment is received) of his "Oracle Core: Essential Internals for DBAs and Developers,"  "Cost-Based Oracle Fundamentals," or "Practical Oracle 8i: Building Efficient Databases" or a $25 Amazon gift card.    Ask to be invoiced to pay next year, but please register to reserve your spot.  Many of Jonathan's seminars have completely sold out. 

This webinar will be recorded and will be available to all attendees for free, unlimited playback until March 7, 2014.

Topic 1

 Introduction
What are we trying to achieve with this course, and what topic areas are we aiming to cover. How does better information about available data structures allow us to improve the efficiency of the database and help us spend less time on maintenance operations.

 
Topic 2

Tablespaces and Files
The large-scale structures in Oracle, where they fit together to make a manageable, recoverable, database. Thoughts on big files vs. small files block sizes, extent and segment space management, logging, default storage, transportable tablespaces, and encryption.

 
Topic 3

Simple Heap Tables
The basic structure; column types, design considerations and storage mechanisms. Some internals, column ordering and chained rows. The importance of constraints. he costs and benefits of compression.

 
Topic 4

Simple B-tree indexes
What they are for, how they are structured. How we need to design indexes. The significance of the clustering_factor, the relevance of number of rows per key value. Maintenance issues and strategies.

 
Topic 5

Views
Views are neither good nor bad, they are just a convenience tool that can be used or abused. How views work, how to manage views.

 
Topic 6

Clusters and Index Organized Tables
Before we get to partitioning, there are structural options in Oracle that allow us to consider “co-location” of similar data items to allow for maximum efficiency during retrieval. We examine the costs, benefits and suitability, and some of the internals, of these structures.

 
Topic 7

Simple Bitmap indexes

What they are, when they are relevant, how they are structured. Maintenance issues and strategies. The implications of “btree/bitmap conversions”. Since bitmap Indexes are available only in Enterprise Edition we review an option for “emulating” bitmap plans with btree indexes.

 
Topic 8

Advanced indexing
Function-based indexes, descending indexes, reverse key indexes; case-insensitive indexes, linguistic indexes, index compression costs and benefits. Problems with indexes.

 
Topic 9

Clones, Triggers and Materialized Views
Performance comes from doing the least work at the right time. We can design a system to do more work when we have spare capacity so that we can do less work when it really matters. We see how materialized views – and “home-grown” variants on the technology – can help.

 
Topic 10

Partitioning
If we can break big objects into little pieces we may be able to work more efficiently by ignoring the pieces we’re not interested in, and changing the way we handle the ones we are interested in. For backup and recoverability it’s helpful to be able to copy large objects in pieces, and even to make as many pieces as possible read-only to reduce the maintenance overheads. Partitioning is a big topic, but we will cover the critical ideas. Partitioning is an extra option on top of the Enterprise Edition.

 
Topic 11

Objects and Large Objects
If we have time at the end of the seminar, this is an optional extra session to cover two of the less frequently used areas of the Oracle database.

The “Object-Relational” database never really acquired much momentum. This is probably a good thing since all it did (at least in Oracle’s case) was decompose objects into a relational form and hide a number of mechanical aids inside the server – making it hard for the developer or DBA to work out how to make their code efficient. We will look at a few details of Oracle’s implementation to explain where the threats lie.
LOBS (large objects) are becoming more popular as CRM (customer relation management) systems start to include geographical information, and companies move to electronic document management. We will examine a few details of how Oracle manages LOBs (and the separately licensed securefiles) and consider the strategies we need to avoid the traps of maintaining very large data items.

 


Have questions about Jonathan Lewis - All new 2-day "Oracle Structures" webinar? Contact Speak-Tech Webinars

When

Monday, February 3, 2014 at 9:00 AM - Tuesday, February 4, 2014 at 4:00 PM (CST)


  Add to my calendar

Organizer

Speak-Tech Webinars

Speak-Tech is Minnesota-based and has organized webinars and seminars featuring the world’s leading Oracle experts for over 12 years.

Speak-Tech has organized over 100 training events for experts such as Jonathan Lewis, Tom Kyte, Cary Millsap, Tim Gorman, Gaja Krishna Vaidyanatha and David Kurtz, considered to be some of the world’s leading experts in Oracle Performance Tuning; Syed Jaffar Hussain, Oracle ACE Director who was awarded the Oracle Excellence Award for Technologist of the Year: DBA, 2011; Steven Feuerstein, considered to the world's leading expert in PL/SQL, Jim Czuprysnski and Matt Hart, all leading experts in their Oracle specialties.

  Contact the Organizer
  News and Updates
Monday, September 9, 2013 - 10:10 AM

Jonathan Lewis's "Oracle Structures" seminar and webinar, scheduled for September 26 & 27, 2013 has been rescheduled to February 3 & 4, 2014. 

You don't need to do anything if you have already registered and are able to attend on February 3 & 4.  I will be happy to give you a full refund for the webinar registration fee on request.

Jonathan and Speak-Tech apologize for the inconvenience.

John Goodhue

Speak-Tech Webinars

 

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.