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.
Day 1: Statistics and Execution Plans
Statistics: Good Practices
Event 10053: Tracing the CBO
Adaptive Cursor Sharing (ACS)
SQL Plan Management (SPM)
Day 2: Some SQL Tuning Tools
Event 10046: Tracing the Execution
Trace Analyzer (TRCA)
SQL Health-Check (SQLHC)
SQL Tuning Test Case Implementation
We expect this class to be completely sold out so please register as soon as possible. Prices go up on January 19.
Refund and cancellation policy: Refund requests will be accepted until January 18. NoCOUG reserves the right to cancel the event at any time and refund all payments. NoCOUG may change the venue to a smaller or larger venue depending on the number of registrations.