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... [Read More]
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... [Read More]
BEST. LOAD. EVER.
21:20:07 up 46 days, 21:24, 1 user, load average: 153.21, 1019.09, 41.21Yeah. 1019.Seen on one of our ISP servers during a recent attempted brute-force password attack.
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... [Read More]
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... [Read More]