• Home
  • Training Days Pre-Conference Day - Practical SQL Tuning

Training Days Pre-Conference Day - Practical SQL Tuning

  • 28 Mar 2016
  • 9:00 AM - 5:00 PM
  • LDS Hospital Auditorium
  • 0

Registration

  • For those who are not attending Training Days 2016.

Registration is closed

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


Powered by Wild Apricot Membership Software