Just to let you know where I’ll be in the near future :)

Seminars

Advanced Oracle Troubleshooting 2.0

I have rearranged and adjusted the material so it flows smoother, has even more practical tools and scripts and describes some internals even deeper ;-)

• 3-5 March – New York
• 15-17 March – San Francisco

These dates are close, last chance to register ;-) Note that after these I won’t be doing an Advanced Oracle Troubleshooting class in US for a while…

Conferences

Hotsos Symposium, Dallas, TX, 8-11 March

I will deliver 2 presentations at the Hotsos Symposium 2010

• Back to Basics: Choosing the Starting Point of Performance Tuning and Troubleshooting Wisely
• Understanding LGWR, log file sync Waits and Commit Performance

Also, I will be the Training Day speaker after the conference (I feel quite honored about this btw ;)

• Scripts and Tools for Oracle Troubleshooting and Advanced Performance Analysis

Note that I will show some very cool (and of course, useful) stuff at the Training Day! Some things are gonna be so cool that I almost want to sit in the audience myself! One of the things is called MOATS – the Mother Of All Tuning Scripts for example ;-)

Miracle OpenWorld 2010, Denmark, 14-16 April

I will deliver two sessions at MOW

• Understanding LGWR, Log file sync Waits and Commit Performance
• Oracle Wait Interface is Useless (sometimes) – together with  James Morle
  

It will be fun! :)

IOUG Collaborate, Las Vegas, NV, 19-22 April

• I will deliver my Practical Oracle Capacity Planning session there

Does “What happens in Vegas…” also apply to all the new stuff learnt at a conference? ;-)

EMEA Harmony 2010, Tallinn, Estonia, 20-21 May

This event will be a blast – awesome speakers (Steven Feuerstein, Tom Kyte, C.J. Date among others) and for the first time the Estonian,Latvian,Finnish and Russian OUG organize such event together (I’m from Estonia originally who don’t know that)

I will deliver a keynote there and one more session:

• Back to Basics: Choosing the Starting Point of Performance Tuning and Troubleshooting Wisely (keynote)
  
• Understanding LGWR, log file sync Waits and Commit Performance

Michigan OakTable Symposium, Ann Arbor, MI, 16-17 September

This will be an awesome event, lots of OakTable people there, including me!

• Back to Basics: Choosing the Starting Point of Performance Tuning and Troubleshooting Wisely
  
• Understanding LGWR, log file sync Waits and Commit Performance

I think we’ll even have a chance to see some football there…

Tanel Poder Cool stuff, Oracle, Training

Advanced Oracle Troubleshooting for DBAs and Performance Engineers

These are the public seminars I will do in 2009. I won’t add any more for this year as my calendar is almost full.

When I published this list last time I told there would be an addition for San Francisco Bay Area people. The event is added below (11-12 Nov).

9-11. September – Hotsos @ Dallas, TX – Postponed to later. I’ll keep you updated.

14-16. September – Hotsos @ Washington, DC – https://portal.hotsos.com/education/SEM/

5-6. October – Miracle @ London, UK – http://www.miraclebenelux.nl/tanel/

8-9. October – Miracle @ Helsinki, Finland – http://www.miracleoy.fi/

2-3. November – Miracle @ Utrecht, Netherlands – http://www.miraclebenelux.nl/tanel/

5-6. November – Miracle @ Brussels, Belgium – http://www.miraclebenelux.nl/tanel/

11-12. November – San Francisco Bay Area, CA – http://www.nocoug.org (more details to follow)

3-4. December – Miracle @ Birmingham, UK (right after UKOUG conference) – http://www.miraclebenelux.nl/tanel/

Conferences 2009

13. Nov NoCOUG Conference – topic TBD

2.Dec UKOUG Tech and EBS Conference

• Latch and Mutex Contention Troubleshooting in Oracle - 1 hour session
• Practical Oracle Capacity Planning – 2 hour masterclass
• Note that I will be doing my 2-day Advanced Oracle Troubleshooting seminar right after UKOUG on 3-4 Dec in Birmingham. This should be a convenient opportunity to fry your brains even more during the same trip.

6. Dec CMG Conference

• How To Do Capacity Planning in Oracle – half day workshop, with Dr Neil Gunther

I will also be around San Francisco when Oracle OpenWorld takes place, I’m not speaking at OOW, but will speak at another special event that same week – so stay tuned ;-)

Tanel Poder Cool stuff, Oracle, Performance, Training, Troubleshooting

I have added a links section into my blog where I put links to useful external documents and tools what I often refer to during my seminars and consulting.

I will make additions to that page over time…

To see the list, you can click on the “Seminar Links” in top right section of the blog page or just click here:

http://blog.tanelpoder.com/seminar/seminar-links/

Tanel Poder Administration, Oracle, Performance, Tools, Training, Troubleshooting

This is the final list of seminars planned for 2009.

Except these I won’t be doing any more public AOT seminars this year as my calendar is almost full up to January 2010.

So if you like my writing, Oracle internals & OS touchpoint, and want to troubleshoot better, check out events in this list :)

15-17. June – Trutek @ Denver, CO – http://www.trutek.com/index.php?id=165

9-11. September – Hotsos @ Dallas, TX – https://portal.hotsos.com/education/SEM/

14-16. September – Hotsos @ Washington, DC – https://portal.hotsos.com/education/SEM/

5-6. October – Miracle @ London, UK – http://www.miraclebenelux.nl/tanel/

8-9. October – Miracle @ Helsinki, Finland – http://www.miracleoy.fi/

2-3. November – Miracle @ Utrecht, Netherlands – http://www.miraclebenelux.nl/tanel/

5-6. November – Miracle @ Brussels, Belgium – http://www.miraclebenelux.nl/tanel/

10-11. November – Northern California (SFO Bay Area, more details in mid-June)

3-4. December – Miracle @ Birmingham, UK (right after UKOUG conference) – http://www.miraclebenelux.nl/tanel/

Tanel Poder Oracle, Performance, Training, Troubleshooting

Just wanted to let you know that there are still places left for my troubleshooting seminar in Edinburgh next week and there’s a 20% discount for UKOUG members.

The event takes place 27-28 April – Check the PiSec seminar page if you’re interested!

Btw I will have whole 10 free days after the Edinburgh event so expect some interesting and useful blog entries then (instead of the marketing stuff what you’ve had to tolerate for last few times ;)

I have moved Snapper v2.01 (out of beta now) to http://www.tanelpoder.com/files/scripts/snapper.sql , it’s layout & output columns are configurable now btw (search for “config” in the script).
If anyone still misses the old version of snapper (v1.07), you can download it from here

Tanel Poder Oracle, Training, Troubleshooting

I’ve been busy with a series of seminars, so haven’t managed to blog much…

Karl Arao has posted some feedback from my Singapore seminar and also the pictures we took with attendees. By the way, he has other good Oracle stuff in his blog so check it out here.

Tanel Poder Oracle, Training

The Miracle Masterclass I delivered last week in Netherlands was awesome, I had lots of attendees and lots of good questions and feedback. As usual, I ran out of time in the end though. I will make this up with some articles about the stuff I didn’t have time to explain :)

I used Snapper v2.0 beta during my demos there and also an improved version of LatchProfX which can give some additional context information about reasons why latches were taken. As they are beta, not final versions, I have uploaded them into a temporary location:

Update: These scripts are out of beta now so here are their permanent locations:

• http://www.tanelpoder.com/files/scripts/snapper.sql
• http://www.tanelpoder.com/files/scripts/latchprofx.sql

Also, the Sesspack (session level statspack) v0.05 files are in my TPT script set, under tools/sesspack_v0.05 directory in the zip file:

• http://www.tanelpoder.com/files/TPT_public.zip

Toine van Beckhoven attended the seminar as well and wrote a review of it, if you’re still hesitating if you should attend as well, read his review first :)

Tanel Poder Cool stuff, Oracle, Performance, Training, Troubleshooting

Here are two more US dates of my Advanced Oracle Troubleshooting seminars, organized by Trutek.

These seminars are 3 days each, so there will be more time to thoroughly explain things and do even more demos!!! :)

10-12. June – Trutek @ Salt Lake City, UT – http://www.trutek.com/index.php?id=165
15-17. June – Trutek @ Denver, CO – http://www.trutek.com/index.php?id=165

Tanel Poder Cool stuff, Internals, Oracle, Oracle 11g, Performance, Training, Troubleshooting

I have created a page where I have links to few slides, my scripts and also my Advanced Oracle Troubleshooting seminar logs (the sqlplus and shell commands I’ve executed and their output with some comments).

To get to that page you need to click on the “Seminar Files” link in the upper right corner of the browser window.

Or you can go directly here: http://blog.tanelpoder.com/seminar/seminar-files/

The slides I showed at RMOUG conference this week are here: http://www.tanelpoder.com/files/Advanced_Oracle_Troubleshooting.pdf. Both Advanced Oracle troubleshooting and SQL execution plan session slides are inside that file.

Tanel Poder Oracle, Performance, Tools, Training, Troubleshooting

First, Happy New Year to you all!

This year I promise to organize my blog a little better, to have some index of my articles, scripts etc :)

Here are the news…

I’ve moved my blog…

In December, when visiting Shanghai, I noticed that my blog was not accessible from there. Apparently the state firewall blocks all access to wordpress.com IPs.

So I have moved my blog to a virtual private server, off wordpress.com – my blog should be accessible from China now as well.

My Advanced Oracle Troubleshooting Seminars in year 2009

If you like the contents of my blog or conference presentations, you’ll sure like my 2-day seminar!

Here are the dates and links for more info:

3-4. February – NYOUG @ New York City – http://www.nyoug.org/etc/training/htm/NYOUG_Training_Session.htm

NB! As this is my first public seminar in US, you’ll be able to attend it for a very very good price! And the early bird registration (which gives you even better price) is open until end of today! More seminars in other US cities are planned for 2nd half of 2009.

2-3. April – Miracle @ Netherlands – http://www.miraclebv.nl/

Probably happens in Utrecht, I’ll keep you updated if it changes.

13-14. April – Oracle @ Singapore – http://www.oracle.com/education/apac/sg_tanel_poder.html

16-17. April – Oracle @ Sydney – http://www.oracle.com/education/apac/au_tanel_poder.html

20-21. April – Oracle @ Melbourne – http://www.oracle.com/education/apac/au_tanel_poder.html

23-24. April Oracle @ Auckland – http://www.oracle.com/education/apac/nz_tanel_poder.html

27-28. April – PiSec Ltd @ Edinburgh – http://www.pisec.org/index.php?option=com_content&view=article&id=6&Itemid=12

11-12. May – Oracle @ Spain – http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?dc=D70365_1060245&p_org_id=51&lang=E&source_call=

18-19. May – Miracle @ Denmark – http://www.miracleas.dk/index.php?option=com_content&view=article&id=100:advanced-oracle-troubleshooting&catid=19:info&Itemid=71

Note that the Advanced Oracle Troubleshooting seminar is meant mainly for experienced DBAs and performance engineers as I go very deep in Oracle internals and OS/hardware details.

See more details about my seminar here

Conferences in 2009

11-12. February – RMOUG Conference @ Denver, Colorado

I will be delivering two presentations about advanced Oracle troubleshooting, tuning and internals:

• Advanced Oracle Troubleshooting: No Magic is Needed, Systematic Approach Will Do
• Understanding Oracle Execution Plans: How SQL is Really Executed

8-12. March – Hotsos Symposium @ Dallas, Texas

I will be delivering two presentations:

• Understanding Oracle SQL Plan Execution: How It Really Works
• Zero Slides: The Scripts and Tools which Will Make Your Life Easier and Allow You to Troubleshoot Better

As the second title says, I don’t use any slides at that presentation, I will just demo some of the scripts and tools I use every day plus few case studies. It will be fun!

Also, I look forward attending the Training Day by Jonathan Lewis on Oracle troubleshooting, on last day of the Symposium.

Tanel Poder Administration, Networking, Oracle, Oracle 11g, Performance, Productivity, Tools, Training, Troubleshooting