Oracle Real World Performance

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
• 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