A b s t r a c t 


 
Presenter: Carlos Sierra
Organization: Oracle Corporation
Biographical Sketch: Carlos Sierra is the author of some popular tools for SQL Tuning: SQLTXPLAIN (SQLT), SQL Health Check (SQLHC) and Trace Analyzer (TRCANLZR) among others. He was a speaker at the 2012 OOW and has been a speaker at other Oracle performance conferences, including the recognized Hotsos Seminar. Carlos currently works in the area of SQL Tuning for the Server Technologies (ST) Center of Expertise (CoE) at Oracle USA. His role includes the design and development of support tools for SQL Tuning, as well as the development and delivery of internal workshops also for SQL Tuning. In addition to these two main functions, Carlos is constantly helping peers and other professionals to diagnose SQL statements performing poorly.
 
Title: Using SQLTXPLAIN (SQLT) to Diagnose SQL Statements Performing Poorly
 
Summary: Carlos Sierra developed the first version of this SQLTXPLAIN (SQLT) tool to help himself during the diagnostics of SQL statement performing poorly. On its first version its name was coe_xplain.sql and it was a simple script. After valuable feedback from several customers, coe_xplain.sql became SQLTXPLAIN (SQLT) and was adopted by a few EBS groups within Oracle. After some exposure to the server technologies team, SQLT became application independent and RAC aware. Today, on its third version, SQLT is widely used by many groups within Oracle, most notably by the query tuning group within support. It has become a preferred tool when the task at hand involves the root cause analysis for a SQL that performs poorly. Delivered by the author of this tool, this in-depth session explains and demonstrates how this SQLT tool helps to diagnose SQL statements performing poorly. It assumes nothing. The session covers SQLT from fundamental concepts, then installation, followed by main methods, SQLT reports navigation, and some special methods. Participants interested in hands-on experience will have the opportunity to practice most of the demos using their own databases either on their laptop or connected to their remote hosts if they can access them from the conference room. The session includes presentations, demos, and significant time for open questions.
 
Topic: DBA Deep Dive
Target Audience: Intermediate
Location: 404
 
 
 


RMOUG Training Days 2013
2520 Independence Blvd., Suite 201, Wilmington, NC 28412
910.452.0006

Conference Administration Tool | Copyright © 2014, Prairie Systems Group, Limited
Page: DISPLAY_PRESENTER_ABSTRACT | Version 1.79