Turn Off db_cache_advice To Avoid Latch Contention Bugs

Originally posted on The Pythian Group blog.A couple of weeks ago, we noticed some timeouts in some of our standard Oracle RDBMS health check scripts on a new instance. I had just migrated this instance to bigger, better, badder hardware and so it had been given more SGA to use,... [Read More]

Setting up Network ACLs in Oracle 11g… For Dummies

Originally posted on The Pythian Group blog.Having recently performed a test upgrade for a client from Oracle RDBMS 10g to 11g, I can tell you that one of the big changes that will likely require action on your part as DBA is the new fine-grained access control for the packages... [Read More]

Sending Timezone-Aware Email with UTL_SMTP

Originally posted at The Pythian Group blog.I’m back again with another in what I hope will be a long line of “Quick Tips for Newbies” series.At The Pythian Group, we have employees all over the globe, from our headquarters in Ottawa to regional offices in Boston, Prague, India and Sydney,... [Read More]

ORA-16069? You May Need A New Standby Controlfile

Originally posted on The Pythian Group blog.On a recent Monday, I had to perform an emergency Oracle standby switchover for a client whose primary instance host had mysteriously rebooted itself over the previous day. Confidence in that host was, understandably, shaken.The Oracle Data Guard configuration is a 3-instance setup using... [Read More]

GNU basename in PL/SQL

Reposted from The Pythian Group blog.In the process of scripting a database migration, I was in need of something akin to the GNU basename utility that I know and love on Linux. basename is most famous for taking a full file path string and stripping away the leading path component,... [Read More]