9:30 am - 4:30 pm
Practical SQL Tuning Workshop
Carlos Sierra & Mauro Pagano, Accenture Enkitec Group
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 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 them both into consideration.
This 1-day training session includes two aspects of SQL Tuning. It provides practical knowledge by diving into the "4 T's" of SQL Tuning: Techniques, Tips, Tricks and Tools; and 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 of interest are selected 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.
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. He 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.
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.He currently works as a consultant for Accenture Enkitec Group, as a member of the Oracle database Health-Check team.