Author: Ivica Arsov

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…

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…

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…

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…