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.
Dr. Statslove or: How I Learned to Stop Guessing and Love the 10053 Trace
This is the long-overdue follow-up post about my recent problems with large partitioned tables and statistics. First and foremost, a huge "Thank You!" to Wolfgang Breitling for his help on this. Wolfgang took pity on me after a pathetic post on oracle-l and held my hand, guiding me into the... [Read More]