Practical SQL Tuning Workshop by Carlos Sierra and Mauro Pagano

Get trained by the experts who wrote the SQL tuning tools used by Oracle Support. Only 50 seats.

Click here to check pricing or to register

SQL tuning is a science. SQL tuning is an art. You may have heard both claims. SQL tuning can indeed be a complex task requiring the use of both sides of the brain: the analytical side and the creative side. This one-day training session focuses on the analytical as well as the creative aspects of SQL tuning: it provides practical knowledge of the 4 Ts of SQL tuning—Techniques, Tips, Tricks, and Tools—and it improves troubleshooting skills by using real-life cases and guiding participants toward possible solutions.

• The first “T,” Techniques, covers the different approaches to SQL performance, from the fundamental steps to identify bottlenecks in SQL processing to the multiple options available in Oracle to improve SQL performance.
  

• The second “T,” Tips, is a collection of best practices and lessons learned throughout the years on how to avoid or address SQL performance issues, especially when it comes to the first reason for poor SQL performance: CBO statistics.
  

• The third “T,” Tricks, groups together all those “mini-tools” you have in your Swiss knife when it comes to tackling and solving SQL problems, covering both custom scripts and standard Oracle APIs.
  

• The last “T,” Tools, is an overview of what is freely available out there in terms of tools for SQL tuning, with special focus on what Carlos and Mauro worked on for many years: SQLT and SQLd360.
  

Analytical and creative thinking are both practiced within a friendly environment where there is no such thing as a dumb question. The target audience for this workshop is developers and DBAs with a desire to increase their SQL tuning skills within a dynamic and participatory environment. Questions are welcomed, and sharing knowledge and experience is encouraged and expected.

Carlos Sierra worked for 17 years in Oracle Support, where he created widely-used SQL tuning tools such as SQLTXPLAIN (SQLT) and SQL Health Check (SQLHC). He is a regular speaker at Oracle conferences such as Hotsos, OpenWorld, UKOUG, RMOUG, and IOUG. He blogs at http://carlos-sierra.net.

Mauro Pagano was a colleague of Carlos in Oracle Support and helped maintain and enhance SQLTXPLAIN (SQLT) and SQL Health Check (SQLHC). His main areas of interest are SQL tuning and CBO internals. He too is a regular speaker at Oracle conferences.

Read the interview with Carlos and Mauro in the NoCOUG Journal.

Refund policy: Full refund available until January 12. No refunds available after January 12. Please send your refund request to contact_nocoug@nocoug.org.