Archive for September 2012
OOW12: Meeting Carlos Sierra face to face
This year I will be attending OOW. Besides presenting SQLTXPLAIN on October 4 at 12:45pm, I will be available at the Oracle Support Stars Bar in case you want to meet.
Moscone West, Lobby Level 2, Oracle Support Stars Bar for Oracle Database and Oracle Enterprise Manager.
- Mon, Oct 1 from 10:00am to 2:00pm
- Tue, Oct 2 from 10:00am to 2:00pm
- Wed, Oct 3 from 9:00am to 1:00pm
If you want to reserve some specific time please text me at 1.407.701.9355 or email me at carlos.sierra.usa@gmail.com, otherwise just stop by. We can chat about anything including SQLTXPLAIN or some SQL Tuning issue you may be working on. If the latter, please try to bring on a USB drive your SQLT files and I will review them with you.
So far I also plan to attend these two events (and any other cool one I get to hear about!):
- Oracle Bloggers Meetup 2012 (Wed, 3-Oct-2012, 5:30pm at Main Dining Room, Jillian’s Billiards @ Metreon)
- Oracle OpenWorld 2012 Tweet Meet! (Tuesday, October 2, from 4:30 p.m. to 6:30 p.m. at the OTN lounge)
I hope to see you there!
OOW OCT 4: SQL Tuning Made Easier with SQLTXPLAIN (SQLT)
Carlos Sierra will be presenting SQLT at OOW on October 4 at 12:45 at the Moscone West – 3022. If you are interested to attend this session please register soon. As of September 5 the assigned room is at 50% capacity. Also, once at OOW please verify room name since we may have had to move this SQLT session to a larger room. Please find below the abstract for this session.
SQL tuning is a daunting task. Too many things affect the Cost-Based Optimizer (CBO) when you’re deciding on an execution plan. CBO statistics, parameters, bind variables, their peeked values, histograms, and a few more are common contributors. The list of areas to analyze keeps growing. Over the past few years, Oracle has been using SQLTXPLAIN (SQLT) as part of a systematic way to collect all the information pertinent to a poorly performing SQL statement and its environment. With a consistent view of this environment, an expert on SQL tuning can perform more diligently, focusing more on the analysis and less on the information-gathering. This tool can also be used by experienced DBAs to make their life easier, at least when it comes to SQL tuning. Learn more in this session.
Carlos Sierra's Tools and Tips 