We are excited to announce a full-day of performance tuning training as a pre-conference event for Training Days! Taught by Carlos Sierra and Mauro Pagano, two of experts from Accenture Enkitec Group on performance and sql tuning. UTOUG will provide lunch for this event.
This event is free for Training Days 2016 attendees. When you register for Training Days, you'll receive a registration code to register for this event for free. Registration is limited so register ASAP to secure your spot!
Practical SQL Tuning
~~~~~~~~~~~~~~~~~~~~
SQL Tuning is a Science. SQL Tuning is an Art. You may have heard both claims. SQL Tuning can be indeed a complex task requiring the use of some attributes of both brain hemispheres: Analytical Thinking and Creativity. If we want to enhance our SQL Tuning skills we may need then to take those two into consideration...
This 1-day training session includes two aspects of SQL Tuning. In one hand it provides practical knowledge by diving into the "4 T's" of SQL Tuning: Techniques, Tips, Tricks and Tools. In the other hand it arouses our troubleshooting skills by using some case studies, guiding participants towards possible solutions. Analytical and Creative Thinking are both taken into consideration and practiced within a friendly environment where there is no such thing as a dumb question.
The targeted audience for this "Practical SQL Tuning" session is both Developers and DBAs, with a desire to increase their SQL Tuning skills within a dynamic and participative environment. Open questions are welcomed, and sharing knowledge and experience is encouraged and expected. In fact, those participants who register early have the opportunity to propose their own SQL Tuning case, and have it either discussed and diagnosed before or during this training session. After all, this is a Practical SQL Tuning session!
Topics are proposed improv by participants at the beginning of the workshop; then immediately voted on. Content sequence of this workshop is driven by weight of topics voted on. A partial list of possible topics include:
Understanding an Execution Plan
Join methods
Operations
Plan Stability
SQL Plan Management
SQL Profiles
SQL Patch
Hints
Plan Migration
With SQL Profiles
With SQL Baselines
Statistics
Schema Object
Dictionary
Fixed Objects
System Stats
Statistics on Global Temporary Tables
Dynamic Sampling
Extended Statistics
Copying Statistics (across environments)
SQL Tuning Tools
Traces (10046 and 10053)
TKPROF
DBMS_XPLAN
SQL Monitor
SQLd360
SQLT and SQLHC
Carlos Bio:
~~~~~~~~~~
Carlos Sierra is a regular speaker at Oracle Users Groups on topics related to Performance and SQL Tuning. He is the author of some legacy tools like SQLTXPLAIN and SQLHC; and of some modern ones like eDB360 and eSP. Carlos has almost 20 years of experience in Oracle databases, and many more on legacy UNISYS and IBM mainframes. Carlos currently works as a consultant for Accenture Enkitec Group, where he leads the Oracle database Health-Check team. Carlos enjoys helping and mentoring others, and contributes to the Oracle community as much as his free time permits.
Twitter: @csierra_usa
Mauro bio:
~~~~~~~~~
Mauro Pagano is a database performance engineer with special interest in SQL Tuning and Wrong Results. He is an active member of the Oracle community, always willing to help or mentor other peers, and he enjoys giving back developing tools and presenting at Oracle User Groups conferences; he is the author of SQLd360 tool and the previous maintainer of other legacy tools like SQLTXPLAIN and SQLHC. Mauro has over a decade of experience in the Oracle world, from database tuning to applications development. Mauro currently works as a consultant for Accenture Enkitec Group, as a member of the Oracle database Health-Check team.
Twitter: @mautro
Feedback