|Sent on:||Thursday, January 3, 2013 2:59 PM|
Day 1: Statistics and Execution PlansStatistics: Foundations Statistics: Good Practices Event 10053: Tracing the CBO Adaptive Cursor Sharing (ACS) SQL Plan Management (SPM)
Day 2: Some SQL Tuning ToolsEvent 10046: Tracing the Execution Trace Analyzer (TRCA) SQLTXPLAIN SQL Health-Check (SQLHC) SQL Tuning Test Case Implementation
Carlos Sierra began his IT career in the late 70s while still a teenager working part-time at his College’s data center. Ever since, he has been developing code. Some time ago it was large applications for UNISYS mainframes. More recently it was internal applications for Oracle itself. His experience in the applications world goes from structural engineering to manufacturing systems, from payroll to Judiciary systems, from small companies to large enterprises, from UNISYS to Oracle to Siebel to PeopleSoft. Over the past few years, Carlos has found a new and dynamic niche at Oracle, contributing to the Center of Expertise within the Server Technologies group. In particular, he specializes in SQL Tuning. When Carlos joined Oracle in the mid 90s, he had the opportunity to contribute working literally in the field, helping strangled customers in the area of manufacturing. Most of the issues he saw somehow involved poor application performance. It was then when he decided SQL Tuning was his call within Oracle. Soon after, he began developing tools to help himself and others alike, facing critical issues that required a quick turn-around. Carlos developed coe_xplain.sql, followed by profiler.sql, Trace Analyzer (TRCANLZR), SQLTXPLAIN (SQLT) and SQL Health-Check (SQLHC). These tools, specially the latter three, are widely used nowadays by Oracle and several enterprises. Carlos loves to learn as much as he loves to share his knowledge. He has developed two SQL Tuning Workshops that he delivers worldwide to Oracle employees eager to expand their knowledge in SQL Tuning. Carlos had the opportunity to speak at Hotsos Symposium 2012 and he is now expanding his experience as a speaker in significant events.