|
Presentations from Previous Conferences
Note: Certain file types may not be handled correctly by IE 7. If a file downloads as a .zip, it may be a .pptx file. If it downloads as a .tar, it may be a .tgz file.
August, 2021:
- Scaling Databases to Infinity and Beyond!—John Kanagaraj (Slides) (Recording)
- Continuous database patching at scale—Pramod Garre (Slides) (Recording)
- The Advantage of Persistent Memory from an Operational Perspective—Vincent Chong and Deepti Sharma (Slides) (Recording)
- Data Lifecycle Management (DLM) on Exadata—Bin Zhang (Slides) (Recording)
- Leverage Exadata Storage cell metrics to solve real-world problems—Paresh Patel (Slides) (Recording)
May, 2020:
-
“Keynote: The World of Data Through the Eyes of PayPal”
- John Kanagaraj, Database Engineering Team, PayPal
-
“Database Infrastructure as Code: Database Builds and Tech Refreshes at Scale:The PayPal Way”
- Indhar Hariharan, Database Engineering Team, PayPal
-
“Highly Secure, Scalable, and Available Key-Value Stores:The PayPal Way”
- Yaping Shi, Database Engineering Team, PayPal
-
“Managing and Scaling Hundreds of Databases with Hera Proxy:The PayPal Way”
- Kenneth Kang and Varun Sankar, Database Engineering Team, PayPal
-
“Scaling Database Infrastructure:The PayPal Way”
- Pramod Garre, Database Engineering Team, PayPal
-
“Understanding the Impact of Cloud Networking on Your Database Applications”
- Mark Ashdown, Real-World Performance Team, Oracle
-
“Maintaining Availability and Restoring Performance After the Glitch Has Gone”
- Mike Hallas, Real-World Performance Team, Oracle
-
“Real-World Performance Techniques for Extreme Data Warehousing”
- Bob Carlin and Mihajlo Tekic, Real-World Performance Team, Oracle
-
“Real-World Performance Techniques for Mixed Workloads”
- Mihajlo Tekic and John Zimmerman, Real-World Performance Team, Oracle
February, 2020:
November, 2019:
-
“Oracle Database: What's New and What's Next”
- Willie Hardie, Oracle
-
“Oracle Autonomous Database: A Look Under the Hood”
- Nilay Panchal, Oracle
-
“Maximum Availability Architecture: Best Practices Updates for On-Premises and Cloud”
- Saurav Das, Oracle
-
“Oracle Active Data Guard: Best Practices and New Features Deep Dive”
- Glen Hawkins, Oracle
-
“Introducing Exadata X8M: Latest Hardware and Software Enhancements”
- Bob Thome, Oracle
-
“Stalking the Hackers: Effective Tips for Auditing and Monitoring Oracle Database”
- Ashok Swaminathan, Oracle
-
“Extra-Large Oracle Databases on AWS”
- Artem Danielov, FlashGrid
-
“Choosing the Right Database Cloud Service for Your Application”
- Tammy Bednar, Oracle
-
“Oracle Data Safe: Securing Databases in the Oracle Cloud”
- Bettina Schaeumer, Oracle
-
“Introducing Gen 2 Exadata Cloud at Customer”
- Bob Thome, Oracle
August, 2019:
-
“Keynote: The Future of Analytics in the Cloud”
- Kent Graziano a.k.a. "Data Warrior," Snowflake
-
“Snowflake: Changing the Game with Cloud Data Warehousing”
- Kent Graziano a.k.a. "Data Warrior," Snowflake
-
“The World's Fastest Database for Operational Analytics”
- Lejo Jacob, MemSQL
-
“Azure Fundamentals 101”
- Kellyn Pot'Vin-Gorman, Microsoft
-
“DevOps or Decoys: Automation in Azure”
- Kellyn Pot'Vin-Gorman, Microsoft
-
“The Modern Data Ecosystem in the Cloud”
- Kellyn Pot'Vin-Gorman, Microsoft
-
“Location! Location! Location!”
- Clay "I've Been Everywhere" Jackson, Quest
-
“Overview of Oracle Autonomous Database Warehouse Cloud Powered by Machine Learning”
- Sergio Castro, Rajneesh Tiwary, and Haimanti Basu; Oracle Corporation
-
“Oracle ADW Cloud & ML Hands-on Lab”
- Sergio Castro, Rajneesh Tiwary, and Haimanti Basu; Oracle Corporation
-
“Oracle Database Security Seminar: Part I”
- Dan Morgan, DBSecWorx
-
“Oracle Database Security Seminar: Part II”
- Dan Morgan, DBSecWorx
-
“Distributed SQL Databases Deconstructed”
- Sid Choudhury & Bryn Llewellyn, YugaByte
-
“How YugaByte DB Works as a Distributed PostgreSQL Database at Scale”
- Sid Choudhury & Bryn Llewellyn, YugaByte
-
Distributed SQL Demo
“Install YugaByte DB”
“Create a local cluster”
“Explore YugaByte SQL”
“See horizontal write scalability in action”
“See high fault tolerance in action”
- Sid Choudhury & Bryn Llewellyn, YugaByte
May, 2019:
February, 2019:
November, 2018:
August, 2018:
- “Keynote: The Future of ETL”
- Gwen Shapira, Confluent
- “Real-Time ETL with Apache Kafka and KSQL”
- Gwen Shapira, Confluent
- “Stream Processing with Oracle’s GoldenGate and Stream Analytics”
- Alex Kotopoulis, Oracle
- “Lightning-Fast RMAN Backups and Restores and Database Duplication Using NVMe Flash Storage”
- Ganesh Balabharathi, Vexata
- “May the Shard Be with You”
- Mike Shurtz, Quest Software
- “Using Thick Database Principles to Leverage Oracle SQL and PL/SQL: Part I—Save Cloud Costs and Simplify User Interface Development”
- Peter Koletzke, Oracle ACE Director
- “Using Thick Database Principles to Leverage Oracle SQL and PL/SQL: Part II—Design, Create, and Maintain a Business Rules Repository”
- Peter Koletzke, Oracle ACE Director
- “Using Thick Database Principles to Leverage Oracle SQL and PL/SQL: Part III—Thick Database Implementation Techniques”
- Peter Koletzke, Oracle ACE Director
- “You CAN Judge a Book by Its Cover: Modernize Your User Interface with Mobile Design Principles”
- Peter Koletzke, Oracle ACE Director
- “Introduction to Microsoft Azure Cloud”
- Sumit Sengupta, Microsoft
- “Running Oracle RAC in Microsoft Azure Cloud”
- Artem Danielov, FlashGrid
- “Introduction to Microsoft Azure Cosmos DB Globally Distributed NoSQL Database Service”
- Sumit Sengupta, Microsoft
May, 2018:
February, 2018:
-
“Licensing, Pitfalls, Options, and Best Practices in the Cloud”
- Michael Stone, CIO, House of Brick and Bob Lindquist, Client Services Director, House of Brick
-
“Keynote: The Future of Transactional Systems”
- Dominic Preuss, Director of Product Management, Google
-
“Lessons from Data Management”
- Wei Hu, Vice President of Development, Oracle Corporation
-
“Everything a DBA Needs to Know About Database and Cluster Maintenance With Gold Images”
- Burt Clouse, Oracle Corporation
-
“Oracle Security for DBAs and Developers”
- Daniel Morgan (Oracle ACE Director Alumnus), Forsythe Meta7
-
“Holistic Database Tuning for DBAs and Developers”
- Daniel Morgan (Oracle ACE Director Alumnus), Forsythe Meta7
-
“Everything Developers Need to Know About Integrating JSON into Oracle Database”
- Mark Drake, Oracle Corporation
-
“Oracle Database 18c Transparent Application Continuity Made Simple With Examples for DBAs”
- Carol Colrain, Oracle Corporation
-
“Solving the Synchronized Data Integration Problem in the Hybrid Cloud”
- Robin Purohit, CEO, griddable.io
November, 2017:
-
“Keynote: Rationalizing Oracle, MySQL, and NoSQL”
- Ritesh Chhajer, PayPal
-
“ Squeezing the Maximum Out of Oracle Database 12c Disaster Recovery”
- Alain Azagury, Axxana
-
“Considerations in a High-Volume and High-Velocity OLTP Database”
- Samrat Roy, Dheeraj Kondapaneni, and Ravi Pedapati, PayPal
-
“Verifying the Quality of Data Replicated by Oracle GoldenGate”
- Dong Wang, PayPal
-
“Sharding in Oracle Database 12c and 18”
- Nagesh Battula and Mark Dilman, Oracle Corporation
-
“Making Hybrid Transactional/Analytic Processing Possible: OLTP + OLAP = HTAP”
- Ganesh Balabharathi, Vexata
-
“Hadoop for Database Professionals”
- Tanel Põder and Michael Rainey, Gluent
August, 2017:
May, 2017:
-
“Oracle Database in Oracle Cloud: Why This Choice Matters”
Robert Greene, Oracle Corporation
-
“Strategies for Migrating to the Public Cloud”
Siddharth Ram, VP & Chief Architect, Intuit Small Business Division
-
“How to Move Your Oracle Database to the Cloud”
Clay Jackson, Quest Software
-
“Are Your End Users Happy with Your Test Data Refresh Solution?”
Alberto Sigismondi, Veritas Technologies
-
“Innovative Oracle Backup and Restore Taken to the Cloud”
Dan Fischer, Veritas Technologies
-
“Running Mission-Critical Oracle RAC Clusters in the Cloud”
Alex Miroshnichenko, CEO, FlashGrid
-
“Deep Dive into Amazon Aurora”
Kevin Jernigan, Amazon Web Services
-
“Getting Started with Amazon Redshift”
Maor Kleider, Amazon Web Services
November, 2016:
August, 2016:
May, 2016:
-
“General Session”
- Laura Ramsey, Oracle Corp.
-
“Keynote: Enterprise-Class Storage”
- Kevin Closson, XtremIO
-
“Active-Active for Oracle Using GoldenGate”
- Janardh Bantupalli, LinkedIn
-
“Scalable High-Performance Flash Systems”
- Jeff Bonwick, EMC
-
“Closing Remarks: Eventual Consistency, Data Quality and CAP”
- Saibabu Devabhaktuni, PayPal
-
“Oracle Exadata: What's New and What's Coming”
- Gurmeet Goindi, Oracle Corp.
-
“Cassandra at eBay”
- Ahbaid Gaffoor & Feng Qu, eBay
-
“What's Next with Oracle RAC”
- Sandesh Rao, Oracle Corp.
-
“Bringing SQL to NoSQL: Rick, Declarative Querying for NoSQL”
- Gerald Sangudi & Keshav Murthy, Couchbase
-
“Modeing Data for NoSQL”
- Patrick Shehan, MongoDB
-
“Three Advantages of Using SharePlex as a Streams Alternative”
- Susan Wong, Dell
-
“Think Outside the Data Center: Monitoring Retail and Cloud Location”
- Roy Prowell, Safeway, Inc.
January, 2016:
-
“Panel Discussion: Making SQL Great Again”
- Andy Mendelsohn, Graham Wood, Hermann Baer, Steven Feuerstein, Bryn Llewellyn, and Kyle Hailey
-
“Get to Grips with SQL Pattern Matching”
- Hermann Bar, Oracle Corp.
-
“Taking Full Advantage of the PLSQL Compiler”
“Taking Full Advantage of the PLSQL Result Cache”
- Steve Feuerstein, Oracle Corp.
-
“12-Step SQL Tuning Method”
- Janis Griffin, SolarWinds
-
“Edition Based Redefinition for Zero Downtime”
- Lee Horner, Salesforce.com
-
“Transforming One Table to Another: SQL or PLSQL”
“Why PL/SQL”
- Bryn Llewellyn Oracle Corp.
-
“Working with JSON Data”
- Dan McGhan, Oracle Corp.
-
“Controlling the SQL Plan Without Touching the Code”
- Kerry Osbonre, Accenture
-
“Same SQL Plan, Different Results”
“Understanding the 10053 Trace”
- Mauro Pagano, Accenture
-
“Real Time SQL Monitoring”
“The Place of SQL in the Hybrid World”
- Tanel Poder, Gluent
-
“MySQL 5.7 Performance”
- Sastry Vedantam & Kathy Forte, Oracle Corp.
-
“Where's Waldo? Using a Brute Force to Find an Execution Plan the CBO HIdes”
- Carlos Sierra, Accenture
-
“Conference Pictures”
-
“Transcript: Making SQL Great Again”
November, 2015:
August, 2015:
May, 2015:
January, 2015:
November, 2014:
-
“ Oracle 12c JSON Document Store”
- Mark Drake, Oracle Corp.
-
“ LOB Internals and Best Practices”
- Mike Rivenes, Oracle Corp.
-
“ Beyond High Availability: Replication's Changing Role”
- Susan Wong, Dell Corp.
-
“ Oracle NoSQL Database”
- Robert Greene, Oracle Corp.
-
“ Toad University: I Didn't Know Toad Could Do That”
- Gary Jerep, Dell Corp.
-
“ Toad University: New Collabaration and Automation Features”
- Daniel Norwood and Gary Jerep, Dell Corp.
-
“ Toad University: Toad Overview and Roadmap”
- Daniel Norwood and Joanna Schloss, Dell Corp.
-
“ Managing a Large OLTP Database”
- Paresh Patel, eBay Inc.
-
“ Database Platform Selection Tool”
- Mansi Narula, eBay Inc.
-
“ Deep Dive - Oracle Sharding at eBay”
- John Kanagaraj, eBay Inc.
August, 2014:
May, 2014:
February, 2014:
-
“Oracle Graph: Graph Features of Oracle 12c”
- Zhe Wu, Oracle Corp.
-
“Oracle Spatial: Spatial Features of 12c”
- Jean Ihm, Oracle Corp.
-
“SQL the Best Analysis Language for Big Data”
- Hermann Baer, Oracle Corp.
-
“Why is My SQL Slow?”
- Bob Carlin, Oracle Corp.
-
“Lies, Damn Lies and I/O Statistics”
- Kyle Hailey, Delphix
-
“Visual SQL Tuning”
- Kyle Hailey, Delphix
-
“Ash Masters”
- Kyle Hailey, Delphix
-
“Instant Cloning: Boosting Application Development”
- Kyle Hailey, Delphix
-
“Oracle ADF in a Nutshell”
- Peter Koletzke, Quovera
November, 2013:
-
KEYNOTE: “Oracle 12c”
- Tom Kyte, Oracle Corp.
- “Advanced Analytic Functions”
- Tom Kyte, Oracle Corp.
- “Fine Tuning Execution Plans for Performance Gains”
- Janis Griffin, Confio
- “Oracle Database Scalability”
- John Karagaraj, PayPal
- “Scaling ETL with Hadoop”
- Gwen Shapira, Cloudera
- “Ten Outrageous Performance Tips”
- Chris Lawson, PG&E
- “Architecting in the Cloud using OBIEE and Oracle Database”
- Mayank Srivastava & Hanan Hit, Xtime
- “Using My SQL for Big Data Advantage”
- Sastry Vedantam, Oracle Corp.
- “Introduction to Building NoSQL Applications”
- Robert Greene, Oracle Corp.
- “SharePlex - Empowering Your Data Sharing”
- Susan Wong, Dell Corp.
- “Active DataGuard Failover”
- Ganesh Sankar Balabharathi, Fusion IO
August, 2013:
-
KEYNOTE: “Soul-Searching for the Relational Camp”
- Iggy Fernandez
-
“Creative Wait Interface Maneuvers”
“Introduction to Time-Based Analysis - Stop the Guessing!”
“Practical Queuing Theory: An Introduction For Oracle Developers and DBAs”
“Understanding And Resolving Free Buffer Wait Contention”
- Craig Shallahamer, OraPub Corp.
-
“ASH Architecture and Advanced Usage”
- John Beresniewicz, Oracle America
-
“Analyze This! Analytic Power in SQL”
“Oracle Partioning - It's Getting Even Better”
- Herman Baer, Oracle Corp.
-
“MySQL Technology Update”
- Lynn Howells, Oracle Corp.
-
“Automatic Data Optimization in Oracle 12c”
- Gregg Christman, Oracle Corp.
-
“Hey, Oracle Optimizer! Don't Mess with MY Plans”
- Janis Griffin, Confio Software
-
“HBase and Lewis Carroll”
- Jeff Bean, Cloudera
-
“NoSQL Drill Down - What is a Graph Database”
- Philip Rathle, Neo4j
-
“Resource Manager 12c Consolidation”
- Sue Lee, Oracle Corp.
May, 2013:
- KEYNOTE: “Schema, NoSql and Data Management”
- Fabian Pascal, Database Debunkings
- “OTN Dev Days files”
- David Peake, Oracle Corp.
- “Diving Into the Latest Oracle Zero Day Bugs”
- Slavik Markovich , McAfee
- “Oracle Database Appliance I/O and Performance Architecture”
- Tammy Bednar, Oracle Corp.
- “RE-Platforming with Zero Down Time Using Oracle Real Cluster, CRS AND ASM”
- Amit Das, PayPal
- “Why and How You Should be Using Policy-Managed Databases”
- Mark Scardina, Oracle Corp.
- “Hadoop for Oracle DBAs”
- Ahbaid Gaffoor, A9
- “Impala: A Modern SQL Engine for Hadoop”
- Justin Erickson, Cloudera
February, 2013:
- “Understanding SQLTXPLAIN (SQLT) Main Report”
- Carlos Sierra, Oracle Corp.
- “The Sins of SQL Programming That Sends the DB to Upgrade Purgatory”
- Able Macias, Oracle Corp.
- “Looney Tuner? No, there IS a Method to My Madness”
- Janis Griffin, Confio
- “Oracle NoSQL Database Hands-On Workshop”
and “Database Management in an Oracle NoSQL Database”
- Anuj Sahni, Oracle Corp.
- “Oracle NoSQL Database and Oracle Database: A Perfect Fit”
- Dave Rubin, Oracle Corp.
- “PayPal's Exadata Journey”
- Amit Das, PayPal
- “Building the Integrated Database Wareshouse with Oracle Database and Hadoop”
- Gwen Shapira, Pythian
- “Big Data: The Big Story”
- Jean-Pierre Dijcks, Oracle Corp.
- “Database Virtualization and Instant Cloning”
- Kyle Hailey, Delphix
- “SQL Injection in Web Applications”
- Slavic Markovich, McAfee
- More to come
November, 2012:
- “5 SQL and PL/SQL things in the Latest Generation of Database Technology”
- Tom Kyte, Oracle Corp.
- “Scaling To Infinity: Partitioning Data Warehouses on Oracle”
- Tim Gorman, Evergreen Database Technologies
- “Fine Tune Oracle Execution Plans for Performance Gains”
- Janis Griffin, Confio
- “Oracle Optimizer: Harnessing The Power Of Optimizer Hints”
- Maria Colgan, Oracle Corp.
- “MySQL 5.6, the Next Generation Database”
- Lynn Ferrante, Oracle Corp.
- “Internals of Active DataGuard” and
“Demo Scripts”
- Saibabu Devabhaktuni, Paypal
- “Scaling To Infinity: Making Star Transformations Sing”
- Tim Gorman, Evergreen Database Technologies
- “The Hitchikers Guide to the Cloud for the DBA”
- Ben Prusinski, VCE
- “Sherlock Holmes for the DBA”
- Kellyn Pot'Vin, Enkitec
- “Database Virtualization and Flexible Cloning”
- Kyle Hailey, Delphix
- “Database Tables to Storage Bits: Data Protection Best Practices for Oracle Database”
- Gurmeet Goindi, Oracle
- More to come
August, 2012:
May, 2012:
February, 2012:
November, 2011:
- “Coding Therapy for Database Professionals”
- Steven Feuerstein, Quest Software
- “Four Things Every DBA and Developer Should Know About Oracle”
- Andrew Zitelli
- “The History of Oracle Performance Analysis”
- Craig Shallahamer, Orapub
- “Oracle Database Appliance”
- Cloud Creek Systems
- “Under The Hood of Oracle ASM: Fault Tolerance”
- Alex Gorbachev, Pythian
- “Making the Most of PL/SQL Error Management Features”
- Steven Feuerstein, Quest Software
- “Real-Time SQL Monitoring”
- Greg Rahn, Oracle
- “Resolving Buffer Busy Waits”
- Craig Shallahamer, OraPub
- “Visual SQL Tuning By Example”
- Kyle Hailey, Delphix
- “Oracle Database Cloud Service”
- Richard Greenwald, Oracle
- “The Case for Manual SQL Tuning”
- Dan Tow, Singing SQL
- “Best Practices for Managing Optimizer Statistics”
- Maria Colgan, Oracle
- “Oracle NoSQL Database”
- Marie-Anne Neimat, Oracle
August, 2011:
May, 2011:
February, 2011:
November, 2010:
- “Oracle Exadata: The World's Fastest Database Machine”
- Ron Weiss, Oracle
- “EXTREME PERFORMANCE TUNING”
- Chris Lawson
- “Reliable Datagram Sockets and InfiniBand”
- Hanan Hit, HIT Consulting Inc.
- “Avoiding SQL Performance Regressions: New Techniques for Solving an Old Problem”
- Prabhaker Gongloor, Oracle
- “Estimating Cardinality and Query Execution Cost: Use of Jonathan Lewis CBO Methodology”
- Dave Abercrombie
- “Building Oracle Enterprise Linux Guests on Virtual Box Windows Host”
- Ahbaid Gaffoor, Amazon
- “Building a Virtualized 11gR2 Linux RAC on a Virtual Box Windows Host”
- Ahbaid Gaffoor, Amazon
- “Oracle Data Warehouse Management With Erwin”
- Don Soulsby, Sandhill Consultants
- “... and UIX Begat ADF Faces: How Rich is ADF Faces Rich Client”
and “White Paper”
- Peter Koletzke, Quovera
- “Visualize Your Data on the Web - The Oracle Fusion Way”
- Shay Shmeltzer, Oracle
- “End to End Complete Oracle 10g Grid Control Implementation”
and “Screen Shots”
- Sakthivel Selvarajan, Ross Stores, Inc.
August, 2010:
May, 2010:
- “Best Practices for Upgrading to Oracle Database 11g”
- Roy Swonger, Senior Director of Database Upgrade Development Team, Oracle Corp.
- “Cost Effective Information Security with Oracle”
- Paul Needham, Director of Database Security Products, Oracle Corp.
- “Capacity Management for Oracle Database Machine Exadata v2”
- Boris Zibitsker, Chairman, CTO BEZ Systems
- “Demystifying Oracle RAC Workload Management Part” and
“Demo files”
- Alex Gorbachev
- “Oracle 11g Reference Partitioning - Benefits and Hazards”
- Andrew Zitelli, Thales-Raytheon Systems
- “SQL Execution Plans, DBMS_XPLAN, and Cardinality Feedback”
- Dave Abercrombie, Convio, Inc.
- “Hello Worldwide Web: Your First JSF in JDeveloper”,
“White Paper” and
“Sample Code”
- Peter Koletzke, Quovera.com
- “Oracle SQL Developer Unit Testing: Testing Your PL/SQL Code”
- Kris Rice, Senior Director Database Tools, Oracle Corp.
- “Recursive Common Table Expressions” and
“White Paper”
- Iggy Fernandez, Database Specialists
- “Integrating SOA and the Application Development Framework”
- Shaun O'Brien, Oracle Corp.
February, 2010:
November, 2009:
August, 2009:
- “What to Expect from the Oracle Optimizer When Upgrading to Oracle Database 11g Release 2”
- Maria Colgan, Oracle Corp.
- “Things You Always Wanted to Know About Oracle Partitioning”
- Hermann Baer, Oracle Corp.
- “Running Oracle in EC2”
- Ahbaid Gaffoor, Amazon
- “Tuning Multi-Terabyte Database for High Performance: An Architecture Approach”
- Daniel Liu, Oracle Corp.
- “The Latest Oracle 11g Gems” and
“trace file”
- Daniel Morgan
- “Closing the Privacy Gap: How Safe is your Data?”
- David Alexander, Data Architect, IBM Optim, Technical Specialist
- “Tuning PL/SQL using DBMS_PROFILER” and
“additional files”
- Tim Gorman, Evergreen Database Technologies, Inc.
- “Introducing Database Modeling and Design with Oracle SQL Developer Data Modeler”
- Kris Rice, Oracle Corp. Development Staff
- “Anatomy of a Database Attack”
- Dana Tamir, Imperva
May, 2009:
February, 2009:
- “Extreme Performance - Exadata”
- Tom Kyte, Oracle Corporation
- “Reorganizing Objects - When and How” plus
“scripts etc.”
- Tom Kyte, Oracle Corporation
- “Empowering Extreme Scalability, Availability, & Efficiency for your Applications”
- Erik Peterson, Oracle Corporation
- “Oracle Data Integration For Data Warehouse Appliances”
- Miranda Nash, Oracle Corporation
- “All About Encryption” plus
“scripts etc.”
- Tom Kyte, Oracle Corporation
- “Best Practices for Oracle Database Administration”
- Iggy Fernandez, Database Specialists
- “Performance Challenges and Tuning a Very Large Data Warehouse”
- Pichai Bala, IBM
- “Hack Your DB Before the Hackers Do”
- Slavik Markovich, Sentrigo
- “DBA's Guide to Physical Dataguard” plus
“ISO file without VMs”
- Ahbaid Gaffoor, Amazon.com
- “Seven Sins of Concurrency” plus
“white paper” plus
“files”
- Chen Shapira, Hewlett Packard
November, 2008:
- “Testing, Testing, Testing”
- Jonathan Lewis, JL Computer Consultancy
- “Beginners Guide To Partitioning”
- Jonathan Lewis, JL Computer Consultancy
- “Xtreme SQL Tuning: The Tuning Limbo” and
“Example”
- Iggy Fernandez, Database Specialists
- “First Failure Fault Detection and Diagnostics: 11g New Features and Novel Methods”
- Jeremiah Wilton
- “Breaking Oracle: Creating Realistic Failures for Testing and Diagnostic Practice”
- Jeremiah Wilton
- “Using Oracle in a Cloud”
- Bill Hodak, Oracle Corporation
- “Oracle's Real Application Testing - How real it is?”
- Hanan Hit
- “SQL Tuning - Reaching Recent Data Fast” and
“White Paper”
- Dan Tow, SingingSQL
- “Database Development Tasks with SQL Developer”
- Kris Rice, Oracle Corporation
- “Service-Oriented Data Management Using Oracle Data Integration”
- Nabin Bilas, Oracle Corporation
- “Oracle Database 11g: Security and Regulatory Compliance”
- Kris Bhanushali, Oracle Corporation
August, 2008:
- “Millsap's Grand Unified Theory of "Tuning"”
- Cary Millsap, Method-R.com
- “Case Studies in Performance Problem Diagnosis and Repair”
- Cary Millsap, Method-R.com
- “Getting Coherence: Introduction to Data Grids”
- Raanan Dagan, Oracle
- “Power at Your Fingertips - Overlooked Gems in Oracle Enterprise Manager”
- John Sheaffer, Oracle Corporation
- “A Tour of the AWR Tables”and
“White Paper”
- Dave Abercrombie, Convio
- “Aces in the Hole: Learning Advanced SQL Techniques from the OTN Forum Pros”
- Greg Pike, Piocon
- “Data Warehousing with Oracle 11g”
- Hermann Bär, Oracle Corporation
- “Introduction to Java-PL/SQL Developers Take Heart”and
“White Paper”
- Peter Koletzke, Quovera
- “What the Oracle Really Meant: The Quest for PL/SQL Testing Using Code Tester”and
“White Paper”
- Arnie Weinstein, Lawrence Livermore National Laboratory
- “Architecting Data Systems for Compliance”
- John Weathington, Excellent Management Systems
- “Building a Web-based Application Using Application Express”and
“Addendum”
- Willie Albino, Lockheed Martin
- “Oracle Fusion Middleware Roadmap & Strategy”
- Margaret Lee, Oracle Corporation
- “Oracle Analytical Functions - the hidden treasure”
- Ron Warshawsky, DBA Infopower
May, 2008:
- “The Best Oracle Database 11g New Features”
- Rich Niemiec, TUSC
- “Oracle Archiving Best Practices”
- Dave Moore, NEON Enterprise Software
- “Oracle Database Security in a Nutshell”
- Daniel Liu, Oracle
- “How Independent Software Companies are Leveraging Oracle Embedded Products in Their Software Applications”
“White Paper”
- Gabe Stanek, Oracle
- “Poor Man's Auditing with Oracle LogMiner”
plus scripts
“lmtest1a.sql” and
“lmtest1b.sql”
- Caleb Small, Caleb.com, Camosun College
- “Natural Data Clustering: Why Nested Loops Win So Often”
“White Paper”
- Dan Tow, SingingSql.com
- “Getting SQL Right the First Try”
“White Paper”
- Dan Tow, SingingSql.com
- “RAC 11g, Virtualization and More...”
- Vijay Ragunathan, Guidewire
- “The Evolving Web UI” --
Download the Powerpoint Viewer 2007
- Avrom Roy-Faderman, Quovera
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
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:
February, 2007:
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:
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:
February, 2005:
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:
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:
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
May, 2002:
February, 2002:
-
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
|
|