How to display database statistics for all objects used in a SQL statement
When my current task is to optimize a particular SQL statement, I find it quite useful if I can...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management | Jared Still (3)
Cleaning up PID files when Oracle GRID/RAC upgrades and patches fail
Unfortunately is it not all that unusual for a patch or upgrade to Oracle Grid or RAC to fail,...
Oracle 12.2 ASM filter driver installation
Recently I needed to install Oracle 12.2 with the ASM Filter Driver for some research on an...
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.
Chart your course with sar
The sar (system activity reporter) is a Linux utility that actually started life long ago in System...
Enqueue bytes - is that a pun?
Sometimes it is necessary to put on your uber-geek hat and start using cryptic bits of code to...
What's eating my database? Where to focus performance efforts using Oracle AWR
No doubt you have at times been on the DBA side of this conversation, or one much like it. Help...
Analyze index validate structure - the dark side
Recently a co-worker wanted to discuss a problem he had encountered after upgrading a database. The...
Improve parsing and query performance - fix Oracle's fixed object statistics
What do I mean by 'fix' the the fixed object statistics? Simply gather statistics to help the...
More fun with oracle timestamp math
Timestamp Math Several years ago I wrote an article on Oracle date math. Amazingly, that article...
