About Me

Hi, as you may have seen from my blog by now, I am an IT-enthusiast, fascinated by the opportunities of using technology to improve our productivity and lives. I’m focused on getting the most out of information technology, both for my clients and for me.

Tanel at Oracle OpenWorld conference

I started my professional career as a part-time C developer at age 16 (was not too good at it though because lack of software engineering experience back then). I got introduced to Unix though, which gave me good foundation for understanding Oracle and enterprise-class applications when I started working for a consulting company at age 19.

By now I have over 15 years of experience managing and improving Oracle-based database and application environments, troubleshooting, tuning, also delivering seminars and training classes of my own.  Currently I’m particularly focused on  helping my customers to implement, troubleshoot and optimize their Exadata solutions so that they would get the most out of their investment!

I took the first public Oracle Certified Master DBA exam in Oracle Education center in Chicago (2002) and became 25th-27th OCM in the world there. 25th to 27th because previously there had been two internal beta exams for Oracle employees and 24 people were certified already, also few people (like Dave Ensor) had received an honorary OCM certificate. There were 4 people taking the exam, but one of them unfortunately lost some data during a simulated crash and a DBA cannot be called a master if they fail to deliver the most fundamendal part of their work – retaining the data. So, 25th-27th it is :-)

Tanel speaking at UKOUG Conference

In 2004 I got invited to the OakTable Network during Miracle Database Forum. I think this is the greatest professional honour and recognition I’ve ever received and I proudly accepted (after having to justify why MS-SQL Server is much better than Oracle to 10+ OakTable members in a public debate). One of the worst hangovers after the party though.

In April 2003 I also got my first international conference speaking experience from IOUG-A Live in Orlando, FL. I spoke about how to do major Oracle E-Business Suite upgrades with minimum downtime for the business. I had about 15 people attending my session in a big 300+ people room. But it looked like they liked it and I sure liked it. Ever since I’ve been speaking at conferences 3-5 times per year, depending on how busy (and lazy) I have been at that particular year.

And now I’m blogging. I hope to give something back to the community, as I have gained so much from it. But also I hope this blog becomes a good way to keep in touch with friends around the world in todays extremely busy life – which we’ll sure improve though, eventually – with throwing even more technology at it ;-)

Happy reading and hopefully commenting too!

Tanel Poder

Update 1: I’m now also an Oracle ACE Director

Update 2: I have teamed up with Enkitec to be part of the world’s most successful Exadata team and I’m building Enkitec’s business in EMEA region.

66 Responses to About Me

  1. Peter says:

    Fantastic to have an Oracle resource as good as this – and free, too! Can’t be bad!
    Usually, IT Geeks are, well, pretty geeky, but dull, too! Not you, though!
    Clearly, you are expert at Oracle troubleshooting, and it’s nice of you to share.
    Knowing how to diagnose is, I think, a tricky thing – even with years of experience.

    You are a cool guy, Tanel!
    Oh. How do you design such brilliant tools such as latchprofx?
    Until I can have your brain (!) I guess I will just have to make do with reading your great blog!

  2. 怀念 says:

    HI
    I am also a oracle database administrator,and have 5 years experiences.

    your blog is so interesting to me.

  3. Tanel Poder says:

    @怀念
    Thanks! I like both writing my blog and sometimes reading it too when I search for some problem in internet and find it’s explained by me in past in my own blog :)

  4. Ian Murphy says:

    Hi Tanel,

    Just wanted to say thanks for your talk at the UKOUG Exadata event yesterday. Was excellent and was just disappointed that you only had an hour!

    Cheers,

    Ian

  5. Tanel Poder says:

    @Ian Murphy

    Hi Ian,

    Yeah, I also think that I had enough material for 2 hours at least. I did only one demo, planned to do more. I think I’ll do an online follow-up event :)

  6. oladiti says:

    this is inspiring…

    thanks

  7. Ganesh R says:

    hi,
    I have a critical performance problem.
    i have a outer join query involving about 10 tables,and recordsa are more than 100 millions. We have a performance issue.Th query takes about 1 minute to fetch (result set is 7 million recs) the records. We need to tune that. We proposed to use a materialiaze view which was fast ( since it will have the result set) but that was not accepted because of we may have about 800 users working concurrently and the updates will kill the performance.
    Pls suggest any alternative methods by which i can work on the result set of the query.

    regards
    Ganesh

  8. Fernando says:

    Amazing, really amazing blog

  9. Rick Lyon says:

    I am having a problem on 11.1.0.7 and Exadata v1 on Linux 64bit on hp.
    10-node RAC database. The issue is with parallel queries going very slow. I saw the same sort of thing happen with two other clients. An Oracle technician in-house says that 11.1.0.7 was short-lived and the only reason it is still around is because of Exadata v1 and the issues it is having.
    Is there something that Oracle does not publish that makes 11.1.0.7 very notorious for query slowdowns on Linus RAC databases? Do you know anything about the version and why many clients have the same issues with having parallel query slowdown issues? And having to flush the shared pool on every node nightly to alleviate slowdown?
    Bug? Does 11gR2 resolve this?
    Please help if you can

  10. Thanks a lot; it is really useful to me.

  11. Mahesh says:

    We are seeing issue related to Identifying the Program name of blocking session Infromation from ASH report.
    The Issue is as follows:
    a) Application A is running for some long time and we see that application B is getting blocked.
    b) After few hours we see that the blocked application A is being killed and Client generate the AWR and ASH report for root cause analysis.
    c) Looking into the ASH report we see that under “Top Blocking Sessions” only the BLOCKING SID is being displayed but under Program column we see “BLOCKING SESSION NOT FOUND”.
    d) Even after connecting to Production database, we see no blocking session information in none of the history view (DBA_HIST_ACTIVE_*/V$ACTIVE_*/V$SESSION)

    As we are in re-active stage of Identifying the Issue, please let us know is there any way in Identifying the blocking program.

    • Tanel Poder says:

      If a session shows a blocking session SID in ASH, but that SID doesn’t show up in ASH at all, this likely means that the blocking session updated some rows (or locked a table, took some enqueue) and then that session was idle after that (while still holding these locks). Idle sessions are not captured in ASH for space/memory saving reasons, so they won’t show up there, but they still can be holding whatever locks they took. This is likely a classic case of a user changing some rows and then not committing. Sometimes this can also happen due to application server/app/network failures where a DB connection gets cut mid-transaction, but the DB hasn’t yet realized that the connection is dead and the transaction should be rolled back.

  12. 大头 says:

    Hi Tanel,
    Your blog are of great help to me!thanks!

  13. Arjun says:

    Hi Tanel, am following your blog intermittent for almost 5 years and reading this blog is asusual interesting and inspiring.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>