Author: Ivica Arsov

Automating Oracle Patching With an Ansible Module

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from the past. We originally published today’s post on February 13, 2019. This blog post has been on my To…

Read More >

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 >

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 >