Author: Ivica Arsov

Cloning a PDB with encrypted data in united mode – avoid ORA-00283

The purpose of this blog post is to give you some guidelines on how to avoid “ORA-00283: recovery session canceled due to errors” during a PDB clone operation and troubleshoot the same. In the Oracle documentation (link), it notes the…

Read More >

Automating Oracle patching with an Ansible module

This is a blog post I had on my To Do list for quite some time. I finally found some time to write about it. I will try to keep it short and clear. In 2017 when I discovered Ansible,…

Read More >

Oracle Scheduler fail to send email notifications

In this blog post I would like to share an interesting issue we encountered couple of months ago related to scheduler job email notifications. As some of you may know, starting with Oracle 11.2 you can subscribe to receive notification…

Read More >

The side effects of drop ‘unused’ index

In this blog post I’ll demonstrate a scenario where dropping a potentially ‘unused’ index can have a negative influence on the optimizer’s cardinality estimation. Having columns with logical correlation and skewed data can cause difficulties for the optimizer when calculating…

Read More >