Google Sites has forced me to upgrade my wiki (https://sites.google.com/site/yetanotherocmoriginal/) to the new version.
Continue readingBook Review: Database Internals
“Database Internals” by Alex Petrov is an interesting and thorough introduction to the design of open-source database engines both as a single instance and as multiple replicas.
Continue readingEffects of O_SYNC Flag on I/O Response Time
I have done some preliminary analysis of the O_SYNC flag on I/O response time. The full report can be found at https://github.com/dfhawthorne/demos/wiki/O_SYNC-and-Blocksize-Effects-on-IO-Performance.
Continue readingBook Review: Site Reliability Engineering
This book review is on Site Reliability Engineering: How Google Runs Production Systems.
ThinkServer system TS130 Last Disk Drive Dies
The last disk drive on my ThinkServer system TS130 has finally died after 7.5 years.
Adrian Colyer: Back under a SQL Umbrella
OCM12C with Ansible Design Journal Entry #15
This is my fourteenth real design journal entry in my series started in “OCM12C with Ansible Design Journal Entry #1”. This entry describes the design decisions made while fixing the issue, “Ping tests show connectivity across interconnect but large packets are dropped #47”
Hero Culture and Incident Preparedness
I think many organisations rely on a hero culture to get through incidents in the production environment. A better solution is to have a prepared and trained team available for incident response.
High CPU Usage with a CDB Resource Plan
During my OCM12C upgrade studies, I wanted to see the effect of using a CDB resource plan on a 12.1 container database (CDB) under high CPU load.
Book Review: Oracle SQL Developer Data Modeler for Database Design Mastery
My review of Oracle SQL Developer Data Modeler for Database Design Mastery is that it is a dense book to read, and is rapidly going out of date as Oracle Data Modeler continues to evolve.
