About this blog
The “Oracle SQL Tuning Notepad” blog is written by Carlos Sierra. The goal of this blog is to share knowledge in Oracle SQL Tuning including around the tools developed by Carlos Sierra in this area. The views expressed on this blog are his own and do not necessarily reflect the views of Oracle and its affiliates. The views and opinions expressed by visitors on this blog are theirs solely and may not reflect his.
About Carlos Sierra
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.