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.


We created this learning library for you so that you can learn the best practices, and methodologies to apply to your Oracle Databases.

Acceso a Real-World Performance Learning Library

Videos

Real-World Performance Introduction
What Does Real-World Performance Mean?
Real-World Performance Education
Real-World Performance Overview
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 #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 #12: Resource Management
RWP #13: Large Dynamic Connection Pools - Part 1
RWP #14: Large Dynamic Connection Pools - Part 2
RWP #15: Index Contention
RWP #16: Application Induced Database Contention
RWP #17: Database Log Writer
RWP #18: Large Pages on Linux
RWP #19: Architecture with an AWR Report