21 September 2007

The Powers of Certification

On the heels of my recent OCAfication, I came across "The power of Oracle certification" which mentions this Dilbert comic that I hadn't seen and made me chuckle. Enjoy.

20 September 2007

HALP

Getting slammed this week. My production instance hanging for 10-15 minutes 2-3 times a day during business hours due to latching on the shared pool and library cache. Oracle "support" seems to be reading from a "fix ur app codez kthxbye" script.

This post from Jonathan Lewis describes the symptoms to a tee.

I'll try to follow-up when we get past this.

18 September 2007

TORA LIVES

And I had just spoken with someone last week about how TOra was dead. Then they come out with a new release.

This was one of my pet projects to maintain back when I worked for Gentoo. A nice alternative to TOAD for those of us fighting to keep our linux desktops.

16 September 2007

BEST. LOAD. EVER.

21:20:07 up 46 days, 21:24,  1 user,  load average: 153.21, 1019.09, 41.21

Yeah. 1019.

Seen on one of our ISP servers during a recent attempted brute-force password attack.

11 September 2007

Understanding System Statistics

Jeremy Scheider's recent post about db_file_multiblock_read_count, a great read in itself, linked me to piece that Jonathan Lewis wrote for Oracle's website entitled "Understanding System Statistics."

Definitely a must-read for anyone taking charge of a 9i or 10g system. I found myself needing to gather system stats again after migrating my database over to a new ZOMG DUAL CORE 64-BIT machine. The numbers were a bit more impressive than the system stats on the old hardware, to say the least. Let's hope that observed performance is equally impressive!

How I Prepared for the Oracle 10g OCA Exam

I thought it might be helpful for those also interested in taking the OCA examination to describe how I prepared for it.

First of all, I've been in the position of Oracle database administrator for 6 years. Practical experience is much more easy to recall than text from a book.

When I expressed my goal of getting OCA and OCP certifications, my employer was very supportive. At my request, the Oracle 10g OCP Certification All-in-One Exam Guide was ordered. This guide was a good read, although it was written prior to 10gR2, and so some of the contents were already outdated. This book also came with a practice exam that I didn't feel was too bad, although it covered Resource Manager, which was not on the OCA exam, nor in my other study guides.

This January, my employer sent me to the Oracle DBA Workshop, the class recommended for the OCA. This class assumes zero knowledge of Oracle, so the majority of it was review, but there were a few nuggets of gold that I put into practice at work. Just to note, the class is not required for the OCA (unlike the Workshop II class being required for the OCP).

My employer also bought the self-study CDs for this workshop. I went through those over the two weeks prior to the exam.

Obviously these things all cost a bit of money, and my employer thankfully covered the cost of all media and training. Hopefully this helps someone out.

07 September 2007

The Perils and Pitfalls of the Foreign Key Constraint Cascading

as told by Laurent Schneider, in which he explains where "1 row deleted." might not mean what you think it means!

05 September 2007

I R OCA

A hoy hoy. Just passed exam 1Z0-042, better known as the Oracle Certified Associate DBA exam.

Let the virgins and wine flow freely.