Paper Title and Abstract

Top 10 Oracle database tuning tips and techniques  

Stream: DBA

The Oracle RDBMS is highly tuneable with many options for optimizing performance. However, the sheer quantity of tuning options can be overwhelming, and you can waste precious time unless you know which tuning activities are most likely to provide a return on your time investment. In this presentation we’ll review ten of the fundamental Oracle performance tuning practices and see how to use these in a systematic way to improve Oracle performance. Topics will include workload and SQL optimization, identification and elimination of key contention points, configuring memory to avoid physical IO, and disk IO optimization. The following topics will be covered: * Adopting a methodical tuning methodology * Building performance into your application design * Indexing wisely * Know your tools * Optimizing the optimizer * SQL and PL/SQL tuning * Conention - the proverbial bottleneck * Optimize memory to reduce IO * Tune IO last, but TUNE it * Exploit RAC, Exadata and 12c.

Pre-requisites:  Basic SQL and Oracle experience

Presentation Objectives:  Attendess will be provided with the fundamental techniques for tuning oracle databases through: * Data modelling and physical database design * SQL and PL/SQL tuning * Managing lock, latch and buffer contention * Optimizing memory allocation * Tuning disk IO * Leveraging advanced features of the Oracle RDBMS

Speaker Details

Guy Harrison is a software professional with more than 20 year’s experience in database design, development, administration, and optimization. He is the author of Next Generation Databases, Oracle Performance Survival Guide and MySQL Stored Procedure Programming as well as well as other books, articles and presentations on database technology. He writes a monthly column for Database Trends and Applications and is an Oracle ACE and a MongoDB certified DBA. Guy can can be found on the internet at www.guyharrison.net, on email at guy.a.harrison@gmail.com and is @guyharrison on Twitter. Guy is a partner at Toba Capital and can be reached there at guy@tobacapital.com.