All articles

GTT in Exadata are eligible to SmartScan

By Franck Pachot . I wanted to check if Exadata predicate offloading can occur on Global Temporary Tables. Actually, I thought it did not and I was wrong. I was ready to post that as an hypothesis for(…)

Sudden drop of the page life expectandy but don’t panic yet!

A couple of weeks ago, I had an interesting discussion with one of my customer about the page life expectancy (aka PLE). He asked me if monitoring the metric value is a best practice because he often noticed a big(…)

SQL Server Database failed to generate a checkpoint

Last time, I experienced a strange error when I tried to perform an integrity check or a simple checkpoint of a database: One or more recovery units belonging to database ‘mydatabase’ failed to generate a checkpoint. This is typically caused(…)

Standard Edition 2 testing the 16 thread limitation

By Franck Pachot . From 12.1.0.2 the Standard Edition - now called Standard Edition 2 - has a few limitations that were not there in SE and SE1. One of them is the limitation to 16 threads. Let's see how(…)

Changing an existing partition configuration … Well, not so easy!

This time let’s talk about an interesting customer scenario where table partitioning was implemented on a table with 100 GB of data on SQL Server 2014. Partitioning in this context aimed to save disk space  (archive data were compressed) , help(…)

Always-on Monitoring EM 13C

As the Enterprise Manager Cloud 12c is configured for sending warnings and alerts if a target database is down, what’s happening if the Enterprise Manager Repository database crashes? With Enterprise Manager Cloud Control 12c, a quite good solution is available: after(…)

EM 13c target is fully broken !!

At a client’ site I decided to install the Enterprise Manager Cloud Control 13c. I did not encountered any special problem :=) , then I installed an agent 13c on the development plattform and added targets as usual, but at(…)

The taboo of ‘underscore parameters’

By Franck Pachot . Oracle provides lots or parameters that can control the behavior of the software. The default values are probably the best ones most of the time. Hundreds of parameters are documented and we can set them to(…)

Dataguard Environment and Database Tempfiles

By Mouhamadou Diaw Last day I found a curious message in the backup alert log in a dataguard environment. The message was related to an issue with the resync catalog and was something like 1 2 3 4 RMAN-00569: ===============(…)

SQL Server AlwaysOn: when a listener becomes the cluster and vice versa

Let’s talk about a funny story that concerns an interesting issue that I faced a couple of months ago at one of my customers. Initially, the problem concerned only the creation of an availability group listener but after deleting the(…)