All articles

When Oracle resets session statistics

By Franck Pachot . During our Oracle 12c New Features workshop I had a very good question about whether the session statistics are reset or not when doing ALTER SESSION SET CONTAINER. My initial thought was that they(…)

Windows Server 2012 R2: solving .NET Framework 3.5 installation problems

I faced a problem at a customer site last week when I tried to install the .NET Framework 3.5 – a prerequisite for installing SQL Server 2012 on a Windows Server 2012 R2. I opened the Server Manager and then(…)

Oracle AVDF – Database Firewall Policies

The successful deployment of a Database Firewall depends on an effective policy. Oracle AVDF includes preconfigured firewall policies as described in the Firewall Policy page in the Policy tab of the Audit Vault Server console. These include policies that log(…)

Oracle 12c privilege analysis rocks

By Franck Pachot . 12c came with a very nice feature: privilege analysis. You don’t know which privileges are required? then just grant DBA, run your application, and check which minimal privileges are needed. And today, I’ve discovered how(…)

WSFC : Manual or automatic failover? That is the question!

During the night, you receive an alert concerning your SQL Server failover cluster or your availability groups and you’re in panic mode because the message displayed is : a failover has occured .. see the log for more details(…)

SQL Server tips: Executing a query with the EXECUTE command

This short SQL Server blog post is meant to help people who have experienced the error messages 2812 and 203 with the EXECUTE command. The goal is to execute a simple query from a variable in a string(…)

Journées SQL Server 2014: il n’est pas trop tard pour vous inscrire

Le plus grand événement français va bientôt avoir lieu (1 et 2 décembre) à Paris et il vous reste  encore une semaine pour vous y inscrire! Pensez également à commander votre lunch(…)

SQL Server 2014: buffer pool extension & corruption

I had the opportunity to attend Paul Randal’s session on advanced data recovery techniques at the Pass Summit. During this session one attendee asked Paul if a page that has just been corrupted can remain in the buffer pool extension(…)

Oracle locks: Identifying blocking sessions

By Franck Pachot . When you have sessions blocked on locks, you probably have all information about the waiters (they call you and anyway their waiting session is visible in v$session our ASH). But you usually need to get(…)

12c SQL Plan Directive: state has changed between 12.1.0.1 and 12.1.0.2

By Franck Pachot . SQL plan Directives have been introduced in 12c. If you have scripts that check their states (and I have that as I prefer to monitor closely the features that are new) you probably have seen(…)