Evening Workshop
 
Home

Maximum Availability Series
Automated Storage Management (ASM)
Data Guard
Dynamic Reconfiguration
Flashback
Grid Control
Online Redefinition
Real Application Clusters (RAC)
Resumable Transactions

DBA Series
11g New features for DBAs
Audit Vault
Disaster Prevention and RMAN
Managing Terabyte Databases
Oracle Security Workshop
Sarbanes-Oxley & HIPAA Compliance

Developer Series
11g New Features for Developers
Advanced Queuing and Streams
Array Processing and Bulk Binding
Exception Handling
Oracle Forms
Procedures, Functions, & Packages
Security and Fine Grained Access Control
SQL and PL/SQL Tuning
SwingBench Installation & Configuration
Triggers

Fusion Middleware Series
Oracle Application Server
Oracle Identity Management

Independent Classes
Interviewing and Hiring Oracle Pros
Oracle for DB2/UDB DBAs & Developers
Oracle for Informix DBAs & Developers
Oracle for SQL Server DBAs & Developers
Oracle for Sybase DBAs & Developers
UNIX, Linux and vi

Evening Workshops
Constraints
Exception Handling
Functions & Pipelined Table Functions
Interviewing
Linux and UNIX Skills
Loops Cursors and Array Processing
Materialized Views
New Objects
Partitioning
Sarbanes-Oxley - HIPAA Compliance
Triggers
Tuning SQL and PL/SQL
Writing PL/SQL Packages
Writing Stored Procedures
11g Tuning SQL and PL/SQL
Been writing SQL for years ... what could possibly be new?
  • ASH
  • AWR
  • DBMS_ADVISOR
  • DBMS_PROFILER
  • DBMS_SQLTUNE
  • DBMS_XPLAN
  • Event 10132

Pretty much everything!

The PSOUG's SQL and PL/SQL tuning workshop is hands-on and intended to help those new to tuning and those with years of tuning experience who want to learn the newest tuning features in 11gR1. 

Tuning started off in the Jurassic period with trial and error: Try this, no try that, no try something else. And when that didn't work get more expensive hardware. Then in the Neolithic period we had the utlbstat and utlestat. And finally, in the last century, we clawed our way up to StatsPack. Now we have the Wait Interface, a number of new built-in packages, and the incredible power of ASH and AWR. Here's an opportunity to learn tuning that works. This 3 hour workshop is only $100/person.
 
2007-2008 Calendar
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct
 
Syllabus
5:45-6:00pm Introductions Join us for coffee before class begins.

To attend a workshop you must register at least one day in advance.
6:00-6:15pm Topic 1 Introduction

Tuning is not buying a bigger box: Adding more RAM, or faster CPUs.

The solution to every problem is not heap tables and B*Tree indexes. We explore the value in global temporary, compressed, index organized, and partitioned tables. Of tables built on hash, index, and sorted hash clusters. Of using bitmap, compressed, and function based indexes.

And even after we have the right object type ... storage parameters, chained rows, clustering factor, cursor sharing, bind variable usage, all affect how our code performs
6:15-7:15pm Topic 2 Explain Plan
Been running Explain Plans for years? Time to throw away that Neolithic script. We will introduce you to the DBMS_XPLAN package and its pipelined table functions while looking at multiple ways to write the same SQL statement. At plan_table$, display_cursor, and to how you can view temp space usage in an Explain Plan. We also demo new Autotrace and tracing event 10132.
7:15-8:00pm Topic 3 Oracle's New SQL Tuning Packages
This section focuses on the new DBMS_ADVISOR and DBMS_SQLTUNE  built-in package. We will show how to leverage these new Tuning Pack capability and use the QUICK_TUNE procedure to have Oracle optimize statements.
8:00-9:00pm Topic 4 Profiling PL/SQL Procedures and Packages
Oracle's DBMS_PROFILER built-in package makes it possible to easily identify which code in PL/SQL objects is being executed, how often, and where the time is being spent. This session focuses on how to implement this feature and interpret the results.
 
Instructors
Jack Cline is the chairman of the Puget Sound Oracle Users Group and has done Oracle contract work in the Puget Sound area for the past 11 years including engagements at Boeing, Bank of America, King County, the City of Seattle, Puget Sound Energy, and the Seattle-King Country Department of Health. He is a frequent guest lecturer at the University of Washington's Oracle Certification Program.
Dan Morgan is an Oracle Ace Director, a 10g and 11g Beta tester for Oracle, and the instructor of the Oracle program at the University of Washington since its inception in 1999. He began his IT career in 1969 with an IBM 370/145, punch cards, and Fortran IV, and though he will vigorously deny it, wrote COBOL for a decade before moving into Oracle about when version 6 hit the market.

In addition to Dan's work at the university he is the Education Chair of the Puget Sound Oracle Users Group, a member of UKOUG, and a member of the British-American Chamber of Commerce in Seattle. He is also a frequent lecturer at training events and at conferences and has presented at Oracle OpenWorld on RAC (2005), at Seattle OracleDay (2004-2007), at numerous government and corporate training events including Apple Computer, Argonne National Laboratory, Boeing Commercial Airplane Group, Dow Jones & Company, Lawrence Livermore National Laboratory, NASA, T-Mobile, US Navy at Pearl Harbor, and Weyerhaeuser to name but a few and presented on Streams and Change Data Capture at UKOUG in 2006.

Dan Morgan is the Morgan behind the "Morgan's Library" website that contains the many demos he has  created for his University of Washington classes as well as for his frequent lectures. He is the former publisher of MacTech Journal, has presented Oracle technical lectures in the US, Canada, Great Britain, and Japan. Morgan is also the author of this course.
 
This is site maintained by the Puget Sound Oracle Users Group. Last Updated: