Tuesday, January 22, 2008

Flying dutch again?

It is pretty evident that keeping a blog updates is not one of my strong points. The purpose of my scribbling is to present my opinion on how my Oracle knowledge increases, and what kind of problems I run into.
I've just finished chapter 6 & 7 (Locking & Latching and Concurrency & Multi-versioning) and the best way to describe how this went, is the reason for the title.
Last year I was flying KLM from Amsterdam to Chicago. The flight itself was fine, service was as expected, but when it came to the TV-programs i struggled a bit. I found myself trying to decipher dutch, with a combination of danish, English and German. The overall storyline was OK, but I was missing most of the details.
I have a good general knowledge of why and how Oracle uses locks/latches, but my brain can't seem to comprehend the technical details. As for concurrency I think my overall understanding of the problem is a little bit better. This is mentioned in several text books as a general problem. When it comes to HOW this is handled in Oracle, it again feels a little like I'm watching the world through my grandma's glasses. I can see the outline, but details are blurry.

I suspect that this will become clearer as my working experience with Oracle increases.


This past week I also held a short session with Thyge, who has been appointed as a kind of mentor for me. This gave me a chance to ask a few of those questions that I couldn't really solve on my own. My biggest challenge overall is probably the PL/SQL syntax used in a few of the examples, ie "How does 'decode' work?"
Also, he was able to share a more "practical" approach to some of these issues. How would he identify a problem on a running system etc.
I expect as the book delves into more technical detail, that I'll use Thyge more and more for questions on different aspects of Oracle.

No comments: