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]
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!