Guy Harrison

Guy Harrison

Chief Technology Officer

dbKoda.com

Biography

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 alumni and a MongoDB certified DBA.

Papers

Oracle Database Tuning 101

Stream:Database / Technology

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

Databases of the Future

Stream:Database / Technology

Over the past ten years the data revolution has been accompanied by a revolution in database systems. The one size fits all RDBMS has given way to a plethora of diverse data management technologies. This talk will survey these new database technologies, consider their utility in leveraging existing data assets and speculate on how these will evolve to meet tomorrows data needs. We conclude with a review of how these trends influence Oracle's data management platform.