Joël Cattin

Oracle 12cR2 : Partitioning improvements – auto-list partitioning

The second release of Oracle Database 12c (12cR2) comes with new improvements regarding partitioning. In this blog post I’ll show one of them : auto-list partitioning. Auto-list partitioning is an extension of list partitioning. It enable the automatic(…)

OTN Appreciation Day : OSWatcher Black Box Analyzer (OSWBBA)

Following my last blog post about OSWatcher, I will present in this one OSWatcher Black Box Analyzer (OSWBBA), which is the tool that you can use to display graphically the data collected by OSWBB. This tool is(…)

OTN Appreciation Day : OSWatcher Black Box (OSWBB)

In this post, I will present a usefull and easy-to-use Oracle tool : OSWatcher. What is it ? OSWatcher Black Box (OSWBB), for its full name, is a free Oracle Tool which will help you to diagnose(…)

“FRA full” alerts flood the Alert Log

We discovered a strange behavior in the Alert Log when the Fast Recovery Area (FRA) is full and the database wants to write something inside it (for example an archivelog). This case concern Oracle 11.2.0.3 databases and higher. Here is a(…)