Oracle SQL Tuning Tools and Tips

SQLTXPLAIN (SQLT), TRCANLZR (TRCA), SQL Health-Check (SQLHC) and SQL Tuning Topics

About

with 3 comments

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.

Written by Carlos Sierra

April 2, 2012 at 5:48 pm

3 Responses

Subscribe to comments with RSS.

  1. Welcome to the blog world! Good to see you here. Look forward to following along with your insights into SQL tuning.

    - Kyle

    Kyle Hailey

    June 5, 2012 at 1:13 pm

  2. [...] Oracle Support to tune SQL statements? You’re right, we’re talking about the one, the only Carlos Sierra, the author of SQLTXPLAIN, TRCA (aka “TKPROF On Steroids”), and SQLHC (SQL Health [...]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 937 other followers

%d bloggers like this: