Oracle Tutorials 2013: Troubleshooting Performance

Europe/Zurich
40-S2-C01 - Salle Curie (CERN)

40-S2-C01 - Salle Curie

CERN

92
Show room on map
Description
In this session, you will learn how to understand what prevents your application from running as fast as you would like (wait event, SQL monitor, Oracle Enterprise Manager, etc.). In a second part, we will give share some indications on how to improve the performance (execution plan, table and index statistics, hinting, SQL baseline, etc.). You will also learn the key points of how to address complex performance issues in a systematic way and to address performance issues in a quantitative way. A few examples and common pitfalls will be presented.
    • 09:00 10:00
      Oracle Performance & Tuning Foundations 1h
      Speaker: Luca Canali (CERN)
      Slides
    • 10:00 10:20
      Coffee Break 20m
    • 10:20 11:30
      Execution Plans & Tools 1h 10m
      Speaker: Dawid Wojcik (CERN)
      Demos
      Slides