Presentation Title: How to Create in 5 Minutes a SQL Tuning Test Case Using SQLTXPLAIN
Speaker: Mr Carlos Sierra
Company: Oracle
Presentation abstract: Creating a Test Case (TC) for SQL Tuning requires a lot of effort. Usually the first goal of this type of TC is to reproduce in a target system the same execution plan observed in a source system. This session shows how SQLTXPLAIN (SQLT) simplifies this task. The components of the SQLT TC are explained. Then a live demonstration is used to show how SQLT easily implements a SQL Tuning TC.

Presentation begins: 03/12/2012 15:50
Presentation duration: 45
Presentation content level: 2 (1 = indepth, 5 = strategic overview)
Audience experience: Experienced (2-3 years)
Audience function: Oracle, Partner, Product Expert
Speaker biography: Carlos Sierra works for Oracle since 1996. At his current role within the Center of Expertise he specializes in SQL Tuning. Carlos is the author of some diagnostics tools like SQLTXPLAIN (SQLT), Trace Analyzer (TRCA) and SQL Health-Check (SQLHC). He has created two SQL Tuning Workshops and has delivered dozens of sessions around the world. Carlos also provides technical assistance in some critical and complex issues in the area of SQL Tuning. Carlos background in Oracle includes EBS, Siebel and PSFT applications. Before Oracle, Carlos developed several enterprise applications for UNISYS mainframes customers.
Related topics: Oracle RDBMS: Database Management, Oracle RDBMS: Grid Infrastructure, Oracle RDBMS: Performance Management
Hall: Hall 1