February, 2008:

• “DB Time-based Oracle Performance Tuning: Theory and Practice”
  and “ASH Report”
  - Uri Shaft and Graham Wood, Oracle Corporation


• “Simplified SQL Performance Management with Automatic SQL Tuning and Real-Time SQL Monitoring”
  - Pete Belknap, Oracle Corporation


• “SQL Performance Analyzer: Testing the Impact of System Changes on SQL Performance”
  - Khaled Yagoub, Oracle Corporation


• “What is New in Oracle SOA Suite”
  - Clemens Utschig, Oracle Corporation


• “Web 2.0”
  - Bradley Brown, TUSC


• “Resolving Conflict with the Arrow of Truth”
  - Bradley Brown, TUSC


• “Oracle Annoyances for Geeks: Deadlocks and Livelocks”
  - Iggy Fernandez, Verizon Business


• “Birds Do It: Migrating Forms to Java EE Web -- A Case Study”
  - Peter Koletzke, Quovera


• “Whither Business Logic?” -- Download the Powerpoint Viewer 2007
  - Avrom Roy-Faderman, Quovera


• “Oracle Adaptive Access Manager: What, Why, How”
  - Dan Norris, Piocon


• “High Availability Options for Oracle Database”
  - Dan Norris, Piocon

October, 2007:

• “Empiricism vs. Guessing Among Oracle Professionals”
  - Jeremiah Wilton, ORA-600 Consulting


• “RAC be Nimble, RAC be Quick”
  - Bert Scalzo, Quest Software


• “Automatic Hang Detection in Oracle 11g”
  - Jeremiah Wilton, ORA-600 Consulting


• “Simulating Oracle I/O Workloads to Accurately Configure Storage”
  - James Koopmann, Database Specialists


• “Made from the Same Mold: Templating Approaches for Fusion Applications” and “White Paper”
  - Peter Koletzke, Quovera


• “Just Get it Written: Deploying Applications to OC4J Using JDeveloper and EM” and “Hands-On”
  - Peter Koletzke, Quovera


• “Moving Oracle Databases across Platforms without Export/Import”
  - Roger Schrag, Database Specialists


• “Oracle DataGuard Standby Features -- Physical vs Logical Standby”
  - Brian Hitchcock, Sun Microsystems


• “Oracle DataGuard Logical Standby Support Issues”
  - Brian Hitchcock, Sun Microsystems


• More to come

August, 2007:

• “Relational Database Industry and Technology Trends”
  - Guy Harrison, Quest Software


• “Oracle Database 10g: Implement Streams”
  - Daniel Liu, Oracle Corporation


• “Back-porting ADDM, AWR, ASH and Metrics to Oracle 9i and Oracle 8i”
  “White Paper”
  “Your tuning arsenal: AWR, ADDM, ASH, Metrics and Advisors”
  “White Paper”
  - John Kanagaraj, DB Soft


• “Reducing Risk of Surprises in Changing Oracle RAC Environment”
  - Dr. Boris Zibitsker, BEZ Systems


• “Systematic Oracle Performance Tuning”
  “White Paper”
  - Guy Harrison, Quest Software


• “Average Active Sessions”
  - Kyle Hailey, Performance Vision


• “RMAN in the Trenches: Part II”
  - Philip Rice, UC Santa Cruz


• “Tracing Individual Users in Connection-pooled Environments with Oracle 10g”
  - Terry Sutton, Database Specialists


• “SOA Project Methodology”
  - Dr. Mohamad Afshar, Oracle Corporation

May, 2007:

• “Fusion: The New Frontier - Oracle Administration in the Future”
  - Steve Lemme, Computer Associates


• “Optimizing SQL in Your PL/SQL Programs”
  - Steven Feuerstein, Quest Software


• “Writing Maintainable Code”
  - Steven Feuerstein, Quest Software


• “Wait-Time Based Oracle Performance Management”
  - Matt Larson, Confio Software


• “AWR: Going Beyond the Scripts Supplied by Oracle”
  - Jerry Brenner, Guidewire Software


• “Diagnosing Bottlenecks in Oracle Streams”and “White Paper”
  - Brian Keating and Chris Lawson, independent consultants


• “RAC for Beginners: The Basics”
  - Dan Norris, IT Convergence


• “Ultimate Guide for Oracle Storage Administration”
  - George Trujillo, Trubix Inc.

February, 2007:

• “Oracle's ASM Reduces Cost of Deploying VLDB”
  - Hanan Hit and Lina Shabelsky, SkyRider


• “Thinking Out of the Box: Redefining Database Storage Management with ASM”
  - Ara Shakian, Oracle Corporation


• “RMAN in the Trenches: To Go Forward, We Must Backup”
  - Philip Rice, UC Santa Cruz


• “Fixing Broken SQL”
  - Dan Tow, Singing SQL


• “Oracle SOA Suite - How to Integrate Databases and Applications into SOA”
  - David Lundvall, Oracle Corp.


• “The Tie That Binds: An Introduction to ADF Bindings”
  - Peter Koletzke, Quovera

November, 2006:

• “Why You Can't See Your Real Performance Problems”
  - Cary Millsap, Hotsos Enterprises


• “Questioning Method R”
  - Cary Millsap, Hotsos Enterprises


• “The New Data Pump”, “Data Pump Article”, “Data Pump Files”, “Oracle Data Pump FAQ”
  - Caleb Small, caleb.com


• “Planning and Installing a RAC Database”
  - Caleb Small, caleb.com


• “Root Cause and Other Urban DBA Legends”
  - Brian Hitchcock, Sun Microsystems


• “RAC Performance Tuning Best Practices”
  - Sri Subramaniam, Oracle Corporation


• “Web Application Security with JAZN - Implementing the Superstition in JDeveloper”, “White Paper”, “Files”
  - Peter Koletzke, Quovera and Duncan Mills, Oracle Corporation


• “Unraveling the Mysteries of Web Application Communications”, “White Paper”
  - Peter Koletzke, Quovera


• “SQL Design Patterns”
  - Vadim Tropashko, Oracle Corporation


• “Developing High-Class UML Class Models”
  - Jeffrey Jacobs, Covad Communications


• “Oracle Workload Characterization”
  - Andy Rivenes, AppsDBA Consulting


• “JSP Web Pages with a Database Backend”
  - Joel Thompson, Rhino Systems

August, 2006:

• “Software Programmers: Heroines and Heroes of the Twenty-First Century”
  - Steven Feuerstein, Quest Software


• “Six Steps to Unit Testing Happiness”
  - Steven Feuerstein, Quest Software


• “How Much do Concurrent Updates Impact Query Performance in Oracle?”
  - Roger Schrag, Database Specialists


• “Top 36 Wait Events” -- Unit1_Intro_to_Waits, unit2_ buffer_cache, unit3_io, unit4_redo, unit5_enqueues, unit6_shared_pool, unit7_sqlnet
  - Kyle Hailey, Independent consultant


• “Issues and Remedies Surrounding Blocking Locks: Asking the Right Questions and Taking the Appropriate Actions”
  - Vilin Roufchaie, DBPulse Group


• “SQL Sucks!” -- plus Journal_Article_Part_1, Journal_Article_Part_2
  - Iggy Fernandez, Verizon


• “Introduction to Oracle Spatial Using Public Data”
  - Richard Flores, Isinglass, Inc.


• “J2EE: Black Box in the Oracle World”
  - Don Bergal, Confio Software


• “Oracle 10g, CoolThreads and Containers”
  - Michael O'Connor, Sun Microsystems


• “Extending OEM Grid Control Functionality With Plug-Ins”
  - Randy Arseneau, BEZ Systems

May, 2006:

• “What's Up with dbms_stats?” and “White Paper”
  - Terry Sutton, Database Specialists


• “Scalable, Fault-Tolerant NAS for Oracle - The Next Generation” and
• “White Paper”
  - Kevin Closson, PolyServe, Inc.


• “Oracle JDeveloper 10g and JavaServer Faces: High-Performance UIs on the Web”
  - Avrom Roy-Faderman, Quovera


• “Performance Diagnostics Using STATSPACK Data”
  - Tim Gorman, SageLogix


• “Services for a DBA: May Your Workloads RIP (Run In Peace)”
  - David Austin, Oracle Corporation


• “Database Security - the Past, the Present, the Future”
  - Mark Kraynak, Imperva, Inc.


• “Strategies and Tools for Centralizing and Automating Database Management”
  - Matthew Zito, GridApp Systems


• “What Does Sarbanes-Oxley Have to Do with the Management of Databases?”
  - Steve Lemme, Computer Associates


• “Religion, Revelation, Revolution! Best Practices and Projects for Managing Databases”
  - Steve Lemme, Computer Associates

February, 2006:

• “Lessons Learned from a Very Large RAC Benchmark”
  - Hanan Hit, Transparency Software


• “Advanced Research Techniques in Oracle”
  - Tanel Põder, Integrid


• “Access and Identity Management for Enterprise Portals”
  - Rohit Gupta, Oracle Corporation


• “Active Session History: A New Performance Monitoring Paradigm”
  - Kyle Hailey, Embarcadero Technologies


• “Web Services, SOA and BPEL -- A Primer”
  - Basheer Khan, Innowave Technology


• “Testing PL/SQL with Ounit”
  - Arnold Weinstein, Lawrence Livermore National Laboratory


• “Hibernate: A Persistence Layer for Java and Oracle”
  - Joel Thompson, Rhino Systems Inc.


• “Introduction to ADF Faces in JDeveloper 10g - Is it Oracle Forms Developer Yet?”
  - Peter Koletzke, Quovera


• “Oracle SQL Developer (formerly Raptor): Introducing Oracle's New Graphical Database Development Tool”
  - Kris Rice, Oracle Corporation


• “SQL Tuning in Oracle Database 10g: The Do's and Don'ts”
  - Mughees A. Minhas, Oracle Corporation


• “Performance Diagnosis Usage Model in Oracle Database 10g”
  - Prabhaker Gongloor, Oracle Corporation

November, 2005:

• “All About Binds” and Files
  - Tom Kyte, Oracle Corporation


• “Logical Standby Databases for Reporting”
  - Mark Bole, BIN Computing


• “Tips and Tricks for Customizing Portal Reports Portlet Modules”and Sample Files
  - Peter Koletzke, Quovera


• “Easy HTML DB”
  - Michael Cunningham, The Doctors' Company


• “JDeveloper 10g and Oracle ADF Business Components: Getting the Most out of Your Data”
  - Avrom Roy-Faderman, Quovera


• “High Availability and Disaster Recovery Techniques and Options”
  - Alok Pareek, GoldenGate Software


• “Practical Space Management in Data Warehouse Environments”
  and White Paper
  - Hamid Minoui, Database Specialists, Inc.


• “Data Vault - What's the Combination?”
  - Jeffrey Meyer, Denver Public Schools

August, 2005:

• “High Availability and Oracle RAC - I”
  - John Sheaffer, Principal Platform Solution Specialist, Oracle Corporation


• “High Availability and Oracle RAC - II”and Java Code
  - John Sheaffer, Principal Platform Solution Specialist, Oracle Corporation


• “Wait Event Enhancements in Oracle 10g”
  - Roger Schrag and Terry Sutton, Database Specialists Inc.


• “Exploring Change Data Capture in Oracle 9i/10g (a Case Study)”
  - Venki Krishnababu, Nordstrom


• “Assertions, Exceptions and Module Stability: Applying Design by Contract to PL/SQL Programming”
  - John Beresniewicz, Oracle Corporation


• “Case Study: Creating Price Lists in an Oracle ERP Dynamic Pricing Environment”
  - Tim Lindemulder, Agilent Technologies


• “Table and Query Design for Hierarchical Data Without CONNECT BY”
  - Charles Yu, Elance


• “When Good Optimizers Make Bad Choices (Sometimes)”, White Paper and Files
  - Dan Tow, Singing SQL


• “Serializability: The Hobgoblin of Little Minds?” and White Paper
  The slides are provided in PDF format. Please rotate the view clockwise in the Adobe Acrobat reader in order to read the slides conveniently. A zip file containing the complete text of the examples in the presentation can be obtained by sending a request to iggy_fernandez@hotmail.com. A follow-up article with detailed analyses and solutions is planned for a forthcoming issue of the NoCOUG journal.
  - Iggy Fernandez, Intacct

May, 2005:

• “Why ‘System’ is a Four-Letter Word”
  - Cary Millsap, Hotsos Enterprises Ltd.


• “Profiling Oracle: How it Works”
  - Cary Millsap, Hotsos Enterprises Ltd.


• “An Oracle 10g Upgrade Case Study: Looking at System Performance Before and After the Upgrade”
  - Roger Schrag, Database Specialists Inc.


• “JDeveloper 10g View Layer Alternatives -JSP and UIX” and White paper
  - Peter Koletzke, Quovera Inc.

February, 2005:

• “Oracle Application Server 10g Release 2 Overview” by Thomas Kurian, Senior Vice President, Oracle Corporation
• “Logical E/R Modeling: The Definition of 'Truth' for Data” by Jeffrey Jacobs
• “Speeding Up Queries with Semi-Joins and Anti-Joins: How Oracle Evaluates EXISTS, NOT EXISTS, IN, and NOT IN” by Roger Schrag
• “Beginning Oracle SQL: Common Idioms” by Les Kopari
• “It’s Time to Do ASH” by Gaja Vaidyanatha
• “Oracle 10g Backup and Recovery New Features” by Daniel Liu
• “A Structured Approach to Database Administration Using the Principles of ITSM and ITIL” by Iggy Fernandez
• “Essentials of Real Application Clusters” by David Austin
• “Minimizing Risks Though Deployment Standardization” by Sudip Datta
• “Oracle10g for Data Warehousing” by Hermann Baer, Oracle Corporation

November, 2004:

• “Conquering Oracle Latch Contention” by Craig Shallahamer, President, OraPub
• “Resource Mapping: A Wait Time Based Methodology for Database Performance Analysis” by Matt Larson, CTO and founder, Confio Software
• “Optimizing Oracle9i Instance Memory” by Lenka Vanek, Sr. Product Manager, Quest Software
• “Managing Oracle Application Server with Oracle Grid Control” by Valerie K. Kane, Group Manager, Lars Ewe, Senior Principal Product Manager, Oracle Corporation
• “Use EXPLAIN PLAN and TKPROF to Tune Your Applications” by Roger Schrag, President, Database Specialists, Inc.
• “Common Performance Monitoring Mistakes to Avoid” by Virag Saksena, CEO, Auptyma
• “Indexing Strategies in Oracle - an Overview” by Scott Martin, President, Terlingua Software
• “Oracle 10g RAC on Red Hat Enterprise Linux 3 with Direct I/O” by Sunil Mahale, Database Storage Architect, Network Appliance
• “I Love the Java Jive: J2EE Overview for Oracle Technologists” and “White Paper” by Peter Koletzke, Technical Director and Principal Instructor, Quovera
• “Introduction to Java - PL/SQL Developers Take Heart!” and “White Paper” by Peter Koletzke, Technical Director and Principal Instructor, Quovera
• “Data Warehousing with MySQL” by Anand Pandey, Senior Consultant, MySQL

August, 2004:

• “Understanding by Design: Why Understanding is Different from Knowing” and “scripts” by Tom Kyte
• “Inside Multiversioning” and “scripts” by Tom Kyte
• “Scaling to Infinity – Partitioning Data Warehouses in Oracle” by Tim Gorman
• “Get a Handle on DDL Changes Using Oracle Streams” by James Koopmann
• “Systems Integration Secrets Using Logical Databases” by Eric Buskirk
• “Introduction to ADF in JDeveloper 10g — Is it Oracle Forms Developer Yet?” by Peter Koletzke
• “The Disaster Diary: Real Failures and Real Recoveries” by Jeremiah Wilton

May, 2004:

• “Choosing the Right Mass Deployment Strategy for Oracle Database 10g Software” by Sudip Datta, Principal Product Manager, Oracle Corporation
• “10G - ASM (Automated Storage Management)” and “New Manageability Features” or “Optimizing Oracle 10g on Linux using Automated Storage Management” by Bert Scalzo, Product Architect, and Lenka Vanek, Product Manager, Quest Software
• “A DBA’s Perspective on J2EE” by Debu Panda, Oracle Corporation
• “Develop, Deploy, and Manage Web Services with Oracle Application Server 10g” by Olivier Le Diouris, Oracle Corporation
• “Increase Java Application Performance with PL/SQL” by Joel Thompson, Rhino Systems
• “Oracle RDBMS patching -- how a fast, simple process can become very slow and complicated.” by Brian Hitchcock, Sun Microsystems
• “The Persistence of Memory (Issues) -- The Shared Pool, Sorting and Other Nightmares” by Brian Hitchcock, Sun Microsystems
• “Reducing Costs of Environment Copies Using Oracle Recovery Manager” by Rich Bernat, ChevronTexaco
• “Oracle's Workspace Manager” by Daniel A. Morgan, Instructor, University of Washington
• “Beginning SQL: Differences Between Oracle and Microsoft” or (White Paper) by Les Kopari, Independent Consultant
• “The Rap on RUP: An Introduction to the Rational Unified Process” by Jeffrey Jacobs, SDLC Methodology and Project Management, Jeffrey Jacobs & Associates

February, 2004:

• Securing an Oracle Database by Noel Yuhanna, Forrester Research

• Information Lifecycle Management Strategies for Oracle Applications Data by Erik Jarlstrom, Princeton Softtech

• Enterprise Manager (EM) 10g Grid Control by Oracle Corporation Product manager's David LeRoy, Cody Maher, and Irina Goldshteyn

• Recent Enhancements in Query Processing in Oracle by George Lumpkin, Oracle Corporation

• Oracle 10g Manageability by Michael Sit, Oracle Corporation

November, 2003:

• Managing an Oracle Optimization Project by Gary Goodman, Hotsos
• Performance Problems from the Field by Gary Goodman, Hotsos
• What a DBA Needs to Know about Oracle’s Bitmap Indexing to Retrieve Data Quickly and about Oracle’s “Star Transformation Query” Processing in a Star Schema. by Vilin Roufchaie, Cingular Wireless

• A Quantitative Basis for Measuring Data Quality Using Metadata by John Murphy, Apex Solutions, Inc.

• Frequently Asked Questions: A Smorgasbord of Common Questions and Problems Received by World Wide Support – and How to Resolve Them. by David Austin, Oracle Corporation

• Help! I Got a Request for ANSI SQL – What Is It, and What Do You Do With It? by Walter Guerrero, Computer Associates

• How Statspack Was Used to Solve Common Performance Issues by Brian Hitchcock, Sun Microsystems

• Working With Partitioned Tables -- The Unpleasant Details by Brian Hitchcock, Sun Microsystems

August, 2003:

• The Burden of Proof by Jonathan Lewis, President, JL Computer Consultancy
• How the CBO Works by Jonathan Lewis, President, JL Computer Consultancy
• More Examples of Interpreting Wait Events To Boost System Performance by Roger Schrag and Terry Sutton, Database Specialists, Inc.
• A Successful Performance Tuning Methodology Using the Database Health Check by Robert Wijnbelt, Systems Consultant Manager, Quest Software

• Database Development with Oracle9i JDeveloper by Brian Fry, Senior Product Manager, Application Development Tools, Oracle Corporation

• Introduction to Using Oracle with Perl and Perl's Database Modules by Randal L. Schwartz, Stonehenge Consulting.

• Converting Oracle Forms and/or PL/SQL to Java by Jennifer McNeill, President & CEO, CipherSoft

• Extending Materialized Views by Noel Reed, Director of Product Management, Bradmark Technologies, Inc.

• Managing Performance Through Versioning of Statistics by Claudia Fernandez, Technical Services Manager, LECCO Technology, Inc.

• Supporting Multiple Development Databases Without Multiple DBAs by Brian Hitchock, DBA, Sun Microsystems

• ETL-There is a New Sheriff in Town - Oracle by Bonnie O'Neil, Apex Solutions, Inc.

May, 2003:

• Implementing Oracle9i Data Guard for Higher Availability by Daniel Liu, Senior Oracle DBA, First American Real Estate Solutions.

• Moving to LDAP: A Step-by-Step Setup of Directory Naming Using OID by Daniel Liu, Senior Oracle DBA, First American Real Estate Solutions.

• Oracle Enterprise Manager (EM V4) by Dave LeRoy and Martin Pena, Product Director, Oracle Corporation

• Implications of Setting Oracle9i's Statistics Collection Level by James Koopmann, Co-Founder and Chief Architect, dbDoctor
• Materialized Views by Willie Albino, Senior DBA, Lockheed Martin

• Achieving Your Project's ROI: Managing the Human Aspects of Project Implementation by Dr. Frances Bruce, Independent Consultant, Bruce Partners Consulting

• Managing What Matters Most - A Holistic Approach to Monitoring Oracle Applications by Steve Coleman, Senior Engineer, Candle Corporation, Consulting & Service

• Managing OLAP Catalog Metadata in Oracle9i R2 Database by Shinji Matsumoto, Vice President of Marketing, IAF Software, Inc.
• How to Figure Out What's Wrong by Thomas Kyte, Vice President, Core Technologies, Oracle Corporation. Download a zip file of demo code and scripts here.
• National Language Support by Brian Hitchcock, DBA, Sun Microsystems
• Eliminating Performance Bottlenecks in J2EE Applications by Rajesh Radhakrishnan, Director of Product Management, Mercury Interactive

February, 2003:

• Much Ado About Nothing (NULL) by Walter Schenk, Principal Consultant, Solutech

• Top Tips for Oracle Designer by Peter Koletzke, Technical Director, Quovera

Java Basics for PL/SQL Programmers by Peter Koletzke, Technical Director, Quovera
• Navigating the Oracle Backup Maze by Robert Spurzem, Senior Product Manager, Legato Systems, Inc.

• Understanding Impact of J2EE Applications On Relational Databases by Dennis Leung, VP Development Oracle9iAS TopLink, Oracle Corporation

• Managing Production Databases - Best Practices by Noel Yuhanna, Senior Industry Analyst, Giga Information Group

November, 2002:

• Applying patches for Oracle Applications 11.x by Ramkumar Srinivasan, DBA, Dreyer's Grand Ice Cream Inc.

• Oracle database consolidation by Noel Yuhanna, Exodus, a Cable & Wireless Company

• Oracle 9.2.0 Partitioning by Eric Yen - Senior Systems Consultant, Quest Software, Inc.

• J2EE and Oracle9i JDeveloper by Peter Koletzke, Technical Director, Quovera

• Using Statspack in Oracle8i and 9i to Identify Problems by Ian Jones, Senior Consultant, Database Specialists, Inc.
• Customer Experience: Building an Oracle Data Warehouse by Saqib Mausoof and Raimundo Reyes, Argonaut Insurance
• Index Strategies for Optimal Performance by Claudia Fernandez, LECCO Technologies, Inc

August, 2002:

• Oracle9iAS Technical Overview byThomas Kurian, Senior Vice President, Oracle 9iAS, Oracle Corporation
• Oracle Backup and Recovery Essentials Every DBA Should Know by Rob O'Brien, Product Marketing Manager, VERITAS Software
• Making the move from ANALYZE to DBMS_STATS by Hamid Minoui & Rajesh Khanna, UPS Freight Services
• PL/SQL Native Compilation, an Implementation Story by Roger Schrag, Senior Consultant, Database Specialists, Inc.
• Top Tips for Web-Deployed Forms by Peter Koletzke, Technical Director, Quovera
• Information Integration Using Oracle Streams by Bob Thome,Group Product Manager, Distributed Databases, Oracle Corporation
• Oracle XML Support by Jinyu Wang, Product Manager, XML Group, Oracle Corporation
• Oracle Text by Ron Hardman, Senior DBA, CommerceOne.com

• Forms Tuning Techniques Users Will Sing Your Praise by Peter Koletzke, Technical Director, Quovera. White paper for this presentation

• Storage Management and Oracle 9i Dean Richards Senior System Engineer, Insession Technologies

• Successful Dimensional Modeling of Very Large Data Warehouses Russell Tuttle Senior Systems Consultant, Quest Software

• Wait Events to Boost System Performance by Roger Schrag, Senior Consultant, Database Specialists, Inc.

• Oracle9i JDeveloper Part I: Introduction and New Features by Peter Koletzke, Technical Director, Quovera

• Oracle9i JDeveloper Part II: Developing Java Client and JSP Applications by Peter Koletzke, Technical Director, Quovera

• Top 7 Oracle Database Tuning Techniques and Case Studies by Lev Moltyaner, Managing Partner, Procase Consulting, Inc.

• Oracle9i Real Application Clusters on 8 Node Intel-based Clusters - An OLTP Case Study , Kevin Closson, Sr. Staff Software Engineer, Database Engineering Group, PolyServe, Inc

Previous years