Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: misc
Buffer cache hit ratio–blast from the past
I was perusing some old content during a hard drive “spring clean” the other day, and I found an old gem from way back in 2001. A time when the database community were trying to dispel the myth that all database performance issues could…
The devastating death PC emoji of doom
So there I am. Sitting at Perth airport. My flight from Perth to Sydney, the first leg on my trip to OpenWorld 2017 is delayed. Of course, delays are not unusual and do not normally bother me. Because I can just flip open my…
Top Ten Travel hints and Tips
Well, let me be honest right at the top here. These are not travel hints These will not help you in any way. This is me having a whine and a rant about a minority of people that I occasionally encounter when travelling….
The village idiot
If you are not familiar with the term Village Idiot, then Wikipedia provides a sufficient definition from which I can base this blog post. https://en.wikipedia.org/wiki/Village_idiot “The village idiot … is a person known for ignorance or stupidity” Over the past couple of weeks I’ve…
Hack-a-Mongo
I was reading an article today about how 10,000+ Mongo installations that are/were openly accessible on the internet have now been captured by ransomware, with nearly 100,000 other instances potentially vulnerable to the same issue. Now, since I’m an Oracle blogger, you may be…
What you "liked" last year…
Well…when I say “liked”, what I mean is “the stuff you all clicked on a lot” last year. Whether you liked it or not will remain one of those great mysteries The top 6 posts from 2016 were: https://connormcdonald.wordpress.com/2015/11/25/ora-14758-last-partition-cannot-be-dropped/ https://connormcdonald.wordpress.com/2013/01/20/exchange-partition-those-pesky-columns/ https://connormcdonald.wordpress.com/2013/08/26/compressed-partitions-are-not-compressed-tables/ https://connormcdonald.wordpress.com/2014/04/12/pluggable-database-and-restricted-sessions/ https://connormcdonald.wordpress.com/2016/06/09/parsing-no-big-deal-eh/ https://connormcdonald.wordpress.com/2016/03/26/are-your-sql-plus-scripts-going-to-ell/…
UKOUG 2016
Just a little video montage of the fun and learning from UKOUG. A great conference every year. I was fortunate enough to receive a Best Speaker award (from a 12c features talk given at the 2015 conference). I gave three talks, one of which…
