BE SHARING

Database management

SQL Server tips: Executing a query with the EXECUTE command

25.11.2014 by Stéphane Haby

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

Database management

SQL Server 2014: buffer pool extension & corruption

19.11.2014 by Microsoft Team

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

Database management

Oracle locks: Identifying blocking sessions

17.11.2014 by Oracle Team

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

Database management

My planning for DOAG 2014

17.11.2014 by Oracle Team

By Franck Pachot . I’m quickly checking the planning for DOAG these 3 days and here is the list of sessions I would like to attend. There are still a lot of interesting ones even if my choice is(…)

Database management

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

16.11.2014 by Oracle Team

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

Database management

Oracle AVDF post-installation configuration

13.11.2014 by Grégory Steulet

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

Database management

AWR does not store explain plan predicates

11.11.2014 by Oracle Team

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

Database management

12.1.0.2 CDB views are now using CONTAINERS()

11.11.2014 by Oracle Team

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

Database management

Oracle SQL Profile: why multiple OPT_ESTIMATE?

08.11.2014 by Oracle Team

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

Database management

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

07.11.2014 by Oracle Team

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