The importance of Oracle database related kernel parameters (aio-max-nr) (with bonus track)
We tend to configure a server following Oracle best practices for the kernel parameters, but what...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management (96)
Standardizing the Oracle GoldenGate Home Path (OGG_HOME)
I don't work with Oracle GoldenGate extensively but when I do I find it somewhat remarkable that...
A serverless audio transcription pipeline
Having attended Serverlessconf NYC a few weeks ago, and given my undying excitement around all...
gh-ost hooks for better visibility
In this post I will show you how to leverage Github's gh-ost hooks for greatly improving visibility...
Sending email from Oracle with utl_smtp via Amazon Simple Email Service (SES)
Note: This article was updated following Symantec Trust issues earlier in 2018.
Dbatools and a SQL Agent
The mission: Tell every DBA around the world about a secret formula that will give them powers....
How to fix an AWR Warehouse after credentials change
We had an AWR Warehouse (AWRW) installation (OEM 12.1.0.5 on Linux) collecting data from +50...
How to analyze SQL server stack dumps
As a SQL Server production DBA, at some point in time you will have to deal with a stack dump. A...
Automating Oracle RMAN backup configuration on Linux with Ansible
Having valid backup of the databases is one of the most important tasks for every DBAs. Having...
Chart your course with sar
The sar (system activity reporter) is a Linux utility that actually started life long ago in System...
