Hotsos Symposium Speaker – Carlos Sierra

Carlos Sierra is a new Hotsos Symposium presenter.

Biography

Carlos SierraCarlos 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

How to create in 5 minutes a SQL Tuning Test Case using SQLTXPLAIN

Abstract

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.

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

The speaker schedule is as follows: