Real-World Performance Learning Library

The Real-World Performance (RWP) Group is part of the Oracle Database Development organization. Engineers in the RWP group focus on extracting the maximum performance from the Oracle Database and hardware in the real-world. We do this by identifying inefficiencies in current systems and applying modern database design and tuning techniques.

Introduction Videos

Real-World Performance Introduction
Real-World Performance Introduction
In this video Andrew Holdsworth, Vice President of Oracle Database Real-World Performance at Oracle Corporation, introduces you to "real-world performance." This is the start of the Oracle Real-World Performance Video series, through which Andrew and his team will share with you the best practices and methodologies you should implement to make the most of your investment in Oracle Database.

Subscribe to this collection, and you will receive notifications when new videos are added!

Duration: 9 mins
Type: Video
Released: 8.8 years ago
What Does Real-World Performance Mean?
What Does Real-World Performance Mean?
In this video, listen and watch Andrew Holdsworth, Vice President of Oracle Database Real-World Performance at Oracle Corporation, as he explains what "real-world performance" means and why you should care. This is the start of the Oracle Real-World Performance Video series, through which Andrew and his team will share with you the best practices and methodologies you should implement to make the most of your investment in Oracle Database.

Subscribe to this collection, and you will receive notifications when new videos are added!

Duration: 4 mins
Type: Video
Released: 11.3 years ago
Real-World Performance Education
Real-World Performance Education
In this video, listen and watch Andrew Holdsworth, Vice President of Oracle Database Real-World Performance at Oracle Corporation, as he talks about how education and communication fits within an organization as vital parts of the system of achieving "real-world performance".

Duration: 6 mins
Type: Video
Released: 11.3 years ago
Real-World Performance Overview
Real-World Performance Overview
In this video, listen and watch Andrew Holdsworth, Vice President of Oracle Database Real-World Performance at Oracle Corporation, as he explains the pitfalls and traps of achieving "real-world performance".

Duration: 9 mins
Type: Video
Released: 11.3 years ago

Core Database Performance Videos

Extreme Transactions Videos

Batch Processing and Loading Videos

Diagnostics Videos

RWP - #19: Architecture with an AWR Report
RWP - #19: Architecture with an AWR Report

Duration: 21 mins
Type: Video
Released: 10.7 years ago

Alert Message

Welcome

Introduction Videos

Real-World Performance Introduction

What Does Real-World Performance Mean?

Real-World Performance Education

Real-World Performance Overview

Core Database Performance Videos

RWP #1: Cursors and Connections

RWP #2: Bad Performance with Frequent Logons

RWP #3: Connection Pools and Hard Parsing

RWP #4: Bind Variables and Soft Parsing

RWP #5: Shared Cursors and One Parse

RWP #6: Leaking Cursors

RWP - #12: Resource Management

RWP - #18: Large Pages on Linux

Extreme Transactions Videos

RWP - #13: Large Dynamic Connection Pools - Part 1

RWP - #14: Large Dynamic Connection Pools - Part 2

RWP - #15: Index Contention

RWP - #17: Database Log Writer

Batch Processing and Loading Videos

RWP #7: Set Based Processing

RWP #8: Set Based and Parallel Processing

RWP #9: Set Based Processing--Data Deduplication

RWP #10: Set Based Processing--Data Transformations

RWP #11: Set Based Processing--Data Aggregation

RWP - #16: Application Induced Database Contention

Diagnostics Videos

RWP - #19: Architecture with an AWR Report

2015 Oracle Openworld Presentations

Turbocharge the Performance of your Data Warehouse

Realizing the Full Potential of Oracle Database On Premise and in The Cloud

Developing Applications for High Performance

2017 Oracle Openworld Presentations

Optimizing Table Scans in Today's Cloud Platforms

Migrating On-Premises Applications to the Cloud: Examining the Connection Strategy

Real-World Challenges with Cloud Migrations and Proof-of- Concept Projects

Applying Oracle Database 12c and Real-World Performance Techniques to SAP

Frame Container

Additional Resources

Survey Region