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!
Debunking the Buffer Cache Hit Ratio
Jonathan Lewis: 1Buffer Cache Hit Ratio: 0
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.