Oracle SQL Tuning Tools and Tips

SQLTXPLAIN (SQLT), TRCANLZR (TRCA), SQL Health-Check (SQLHC) and SQL Tuning Topics

2-days open SQL Tuning Class in Pleasanton, CA this month!

with 9 comments

I will be delivering a two-days SQL Tuning class on February 19-20 in Pleasanton, CA. It is available to registered Oracle Users thanks to the help from NoCOUG. Space  is limited, so if you want to attend you need to hurry up.

This class covers:

  • CBO statistics (fundamentals and good practices);
  • Tracing with Events 10046 and 10053;
  • Plan Stability with Adaptive Cursor Sharing (ACS) and SQL Plan Management (SPM);
  • SQL Tuning tools: Trace Analyzer TRCANLZR (TRCA), SQLTXPLAIN (SQLT) and SQL Health-Check (SQLHC); and
  • SQL Tuning Test Cases (creation and implementation).

This is the first time this 2-days class is offered outside Oracle. Its content is an extract of the internal SQL Tuning Workshops I have developed and delivered to over 700 Oracle Engineers around the globe.

This is not an Oracle University (OU) class, which means the scope is more into the actual trades of the day-to-day life of SQL Tuning and less into product features. So if you have taken a SQL Tuning OU class, then this 2-days session would be a nice addition.

Another thing that you should expect from this class is lots of participation. In my sessions I always encourage participants to bring to the table their current SQL Tuning issues or concerns, so we can openly analyze and discuss them during class. The environment is friendly, welcoming and open.

I hope you can join us on February 19-20.

9 Responses

Subscribe to comments with RSS.

  1. Please let me know if i can attend this session online through bridge…

    Thanks

    Yousuf

    Yousuf

    February 3, 2013 at 3:03 am

  2. Hey Carlos,

    Great to see you giving high quality classes, thank you! Any way you can record/ do also webex session as is hard for most of people to travel to US – will be easier for me from UK to watch.

    Thanks,
    Dani

    DanyC

    February 3, 2013 at 7:48 am

    • Hi NoCOUG,

      Is this online session available .. we do not want to miss this classes..Specially from Carlos

      Thanks

      Yousuf

      Yousuf

      February 4, 2013 at 2:35 am

      • Yousuf,
        Check in NoCOUG how to contact them.
        Cheers — Carlos

        Carlos Sierra

        February 4, 2013 at 6:50 am

    • Dani,
      You may want to check with the NoCOUG if they plan to record the session and make it available to members.
      Cheers — Carlos

      Carlos Sierra

      February 4, 2013 at 6:48 am

  3. [...] 2-days open SQL Tuning Class in Pleasanton, CA this month!. [...]

  4. Hi Carlos,

    I’m Erika from Sao Paulo, Brazil. Do you have an schedule class on April or May?

    Thanks,

    Erika.

    Erika Nagamine

    February 12, 2013 at 9:02 am

    • Erika,
      If you mean internal SQL Tuning Workshops, you can check our internal CoE website http://coe.oraclecorp.com. If you mean external webinars or short classes like this, then the answer is: we do not have an schedule. Both internal and external are only scheduled as per special requests from teams or OUG.
      Cheers — Carlos

      Carlos Sierra

      February 13, 2013 at 6:16 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 937 other followers

%d bloggers like this: