Oracle Sean
Ramblings of an Oracle DBA
Monday, February 19, 2018
Rapidly increasing numbers of scheduler jobs in Oracle (11gR2 edition)
›
I recently encountered an interesting issue in our Oracle 11gR2 databases (it occurs in 12c also) where the number of scheduler jobs increas...
Friday, December 8, 2017
Persistent Data Volumes for Oracle in Docker
›
A good use of Oracle on Docker is for building out test environments. Developers can spin up an Oracle database as part of an application st...
Thursday, June 22, 2017
Sending messages from an Oracle database to Slack
›
Slack is becoming a standard tool for communication among DevOps teams. It's easily extensible and integrated into systems, providing a ...
Tuesday, December 6, 2016
Adding a schema to an active SharePlex configuration
›
In this post I'll address how to add a new schema to an active SharePlex configuration. This procedure doesn't require you to recrea...
Tuesday, May 24, 2016
Improving the performance of ORDER_LASTMOD_IDX on DCSPP_ORDER in ATG
›
I just stumbled on Metalink article 1603359.1, which recommends that ATG customers encountering contention on the ORDER_LASTMOD_IDX index on...
Friday, March 11, 2016
A CRS Action Script for Solarwinds Database Performance Analyzer (DPA)
›
I've been using Solarwinds DPA for a few years now and find it to be a great tool for monitoring Oracle databases. It's one of the ...
Tuesday, March 8, 2016
The correct answer to the interview question, "Have you ever had to restore using a backup?"
›
I'm constantly amazed by the answers DBA candidates give to the question, "When was the last time you had to restore using a backup...
Home
View web version