All articles

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(…)

Oracle AVDF post-installation configuration

In one of my last blog, named: “Oracle Audit Vault and Database Firewall (AVDF) 12.1 – installation on VirtualBox” I explained how to install AVDF on VirtualBox. Since some of you asked for a blog on “How to(…)

AWR does not store explain plan predicates

By Franck Pachot . What is the most important part in an execution plan? It’s probably the predicate section. It helps to see implicit conversions. It helps to understand why an index is used or not. Or to see(…)

12.1.0.2 CDB views are now using CONTAINERS()

By Franck Pachot . I’ve blogged about multitenant internals at the time when 12.1.0.1 was just released. Something has changed in 12.1.0.2 and blogging about it was in my todo list for a long time. Now the occasion(…)

Oracle SQL Profile: why multiple OPT_ESTIMATE?

By Franck Pachot . In a previous blog I’v shared my script to retrieve the OPT_ESTIMATE hints from a SQL Profile. In the example I made, I had two lines for each table: --- PROFILE HINTS from dbiInSite(…)

Oracle SQL Profiles: Check what they do before accepting them blindly

By Franck Pachot . People often ask me if I use the SQL Tuning Advisor. The answer is no, at least not through the end of it. But don’t take me wrong. SQL Tuning Advisor is a really nice(…)