Friday, January 6, 2012

Hotsos Symposium 2012 Speaker Spotlight - Carlos Sierra

Biography: Carlos has collaborated with Oracle Support since 1996. During this time, he has rotated through several groups including: EBS Manufacturing, Field Support, EBS Center of Expertise COE and for the past 5 years Server Technologies COE.

Carlos is the author of SQLTXPLAIN. A tool that is becoming the preferred choice by Oracle Support and Development to analyze and diagnose SQL statements performing poorly. This tool has been his main contribution to Oracle and the community for the past 10 years.

Carlos has been a speaker in regional Oracle user's groups in Florida. He has delivered several WebCasts about SQLTXPLAIN to Oracle's customers. He has developed two advanced Oracle internal workshops in the area of SQL Tuning and delivers them all over the world.

Carlos has made SQL Tuning his daily job and cherished hobby. He is always willing to help others when they need a second pair of eyes to review an issue in the area of SQL Tuning.

Presentation Title and Abstract: How to Creat in 5 Minutes a SQL Tuning Test Case using SQLTXPLAIN

Creating a reproducible Test Case is frequently a necessary step to progress a SQL Tuning issue. Oracle Support requires this all the time.

A Test Case needs the metadata to re-create the schema objects accessed by the SQL statement. It also requires the CBO schema object statistics. The CBO system statistics may be also needed. The entire CBO environment is a must (Parameters and Fix Control). Specific CBO Parameters set at the time the SQL was parsed are needed. The values of the bind variables at the time the SQL was parsed are also needed. Other elements may be required like Constrains and Policies.

Putting together a Test Case is not an easy task. The good news is that every time you use SQLTXPLAIN on any of its main methods (XTRACT, XECUTE, XTRXEC and XPLAIN) a Test Case is assembled and included within the output of SQLT. So, when you send to Oracle Support a SQLT ZIP file it includes such Test Case.

During this presentation, you will learn how to implement a SQLT Test Case as Oracle Support does. You can benefit from this functionality by easily creating a Test Case from your Production environment into your Test system. There you can apply some "what if" tests or reduce your TC in order to simplify it. You can even create a Test Case out of another Test Case. Being able to easily "copy" the tuning environment for a particular SQL from Production into Test is very desirable if you or your team perform in-house SQL Tuning.

Now...don't you want to sign up for Hotsos Symposium 2012? If Carlos' presentation doesn't tempt you, you may want to take a peek at our Speaker page at to see if any other's do. You won't find another conference completely dedicated to Oracle performance optimization. To sign up, please visit Registration. We hope to see you in March!

No comments: