Day_1_Part_01_Intro

Real-World Performance
Oracle Real-World Performance Team
Oracle Product Development
What is Real-World Performance ?
Bridging the Divide from Today’s Performance to What is Possible
Real-World Performance
Who We Are
•Part of the Database Development Organization •Global Team located in USA, Europe, Asia
•300+ combined years of Oracle database experience •Innovate to achieve exceptional Database Performance •Our methods:
•Use the product as it was designed to be used
•Numerical and logical debugging techniques
•Top down approach to performance engineering
Real-World Performance
What we do
•Support field organization on high profile PoCs and escalations •Work with internal applications groups to drive database performance •SAP performance
•Educate others about the best performance methods and techniques •Work with developers to improve the product
Root Causes of Suboptimal Database Performance
The database is not being used as it was designed to be Used The application architecture/code
design is Suboptimal
There is a suboptimal algorithm in
the database
Root Causes of Suboptimal Database Performance
Where database users look for performance improvements
Perception
Application
Algorithms and
Correct Product
Usage
Database
Platform The best place to look for performance Improvements
The Real World Performance Perception Problem
Reality
Application
Algorithms and
Correct Product
Usage
Database
Platform
Recent Results 1000X Oracle Applications Project
Baseline: 4.3 Hours Code Changes: 4.3 Hours Correct Usage: 29 Secs Platform: 12 Secs Final: 12 Secs Speed up: 1290 Baseline: 2.4 Days
Code Changes: 27 Mins
Correct Usage: 7.5 Mins
Platform: 4.5 Mins
Final: 4.5 Mins
Speed up: 768
Baseline: 2.5 Hours
Code Changes: 2.5 Hours
Correct Usage: 4 Secs
Platform: 0.90 Secs
Final: 0.90 Secs
Speed up: 10000
How Does Your Organization Do Performance ?
•Conventional
–Focus is on “Good Enough” or “What the Business Needs”
–Process Orientated/Part of QA
–Spends most the time on Platform
Tuning Issues
–Only changes things within limited
scope
–Bottom up tuning approach
–Looking for incremental gains •Real-World
–Focus on excellence and what the
hardware and software can do
–Innovate excellent performance and
add intellectual property to your code –Everything is within scope
–Holistic top down approach
–Focus on orders of magnitude gains
Real-World Performance 2015
Todays Real World Performance Challenges/Opportunities
•Observed Behavior Seen in the Real World
–Incorrect use of Database and Tools
–Applications designed for small datasets working on large datasets •Performance Improvement Opportunities
–Order of magnitude performance improvements for data intensive workloads –Improved performance and reliability for OLTP system with heavy workloads •Management Challenges
–Education
–Moving the focus from platform tuning to application code improvement
Real-World Performance 2015
Incorrect use of Database
•Unstable OLTP systems due to inappropriate connection pool strategies in Middleware
–Connection storms and CPU oversubscription race conditions
–Resource leakages due to undetected programmer error
•Sub optimal execution plans—by design or by accident
–Incorrect or Outdated statistics gathering techniques
–Excessive or inappropriate hinting technique
–Inappropriate Physical design—partitioning , indexing, compression •Selective De-Tuning of databases in production
–Incorrect or legacy init.ora setting
Real-World Performance 2015
Applications designed for small datasets working on large datasets •Prevalence of put/get a row/object type processing in todays applications •Non scalable, contentious designs
•Missed batch windows due to serial/non scalable/algorithmically weak application designs
•Lack of appreciation of SQL and database performance capabilities
–Set based coding techniques
–SQL pipelining techniques
–Transformational techniques on Big datasets
Real-World Performance Programs
Oracle Open World
Real-World Performance
Oracle Open World 2014 Sessions
What the Real-World Performance Team Learns from Your Automatic Workload Repository Report
Real-World Performance of Star and Snowflake Schemas, Part 1: The Theory Real-World Performance of Star and Snowflake Schemas, Part 2: The Reality
Real-World Performance
Oracle Open World 2015 Sessions
Optimizing SQL for Performance and Maintainability—a Panel Discussion
Real-World Tales: Realizing the Full Potential of Oracle Database on Premises and in the Cloud
Developing Applications for High Performance: does One Size Fit All?
Turbocharge the Performance of Your Data Warehouse
One Day Real-World Performance Road Show
Real-World Performance Tour in Association with IOUG Featuring Andrew Holdsworth, Tom Kyte and Graham Wood
•Beijing May 20
•Shanghai May 22
Online Education
Real-World Performance
Online Video Series
•Real-World Performance Engineers discussing and demonstrating performance issues, root causes and when to apply the correct techniques –The Optimizer
–Core DB Performance
–Extreme OLTP
–Extreme DW
•/goto/oll/rwp
Real-World Performance Training
Real-World Performance Classroom Training Classroom Training
• 4 Day Class of Intensive Performance Training
–Topics: The Optimizer, Core DB Performance, Extreme OLTP and DW –Classroom, Demos, Hands On, Test and Quizzes
–Training given by Real-World Performance Engineers
–Designed for Architects, Developers and DBAs
–4 months training in 4 days
•Contact RWP or you local Oracle team to apply
Real-World Performance Training
What you will learn
•Understand how the optimizer works and how it is influenced •Learn the fundamentals of core database performance –Database Computer Science
–Application Algorithms
–When to apply the correct tools and techniques
•Extreme OLTP
–Connection Management, Contention and Tools
•Extreme Data Warehousing
–Working with large data sets
–DW Techniques: Set based processing, Exadata, Database In-Memory, Parallel
Agenda
Core Oracle Database Performance Fundamentals Extreme OLTP SQL and the Optimizer Extreme Data Warehousing Review and Team Exercise
1
2
3
4
5
Student Challenge
•This class is designed to make you think about performance and NOT necessarily how to do it.
•Real-World Performance consists of the following:
–The ability to articulate with numbers and facts where a performance problem exists –Propose a solution based on
•Good computer science and engineering principles
•Anticipated results and supporting data
•Aspiration for “Excellence” and never “Good Enough”
–The ability to match appropriate database technology to the challenge
Real-World Performance Classroom Training
Quotes
•“Fantastic –such a good course. Why can’t all training be like this?”
•“The demos schooled me”
•“Content matches the real world—totally different than courses offered by Oracle University”•“Your understanding of Oracle real life problems, familiarity with computer science basics and procedures, teaching excellence, and interpersonal skills all contributed to a successful training”—
Venkat Dulla, Qualcomm
•“Anyone out there claiming that he/she is an Oracle DBA must attend RWP classes. We are highly experienced team of DBAs and we thought we’ve seen it all until this class ! Real problems that we are dealing day-to-day, like connection storms, was turned into training scenarios and explained so clearly with cause and solutions along with a diagnostic methodology…it was also an eye-opener for OLTP DBAs that I/O is no longer a bottleneck with exadata and it is time to start using set operations to achieve order of magnitude performance gains” –Metin Ylimaz, Turkcell。