Database Administration & Monitoring

SQL Server 2016 query store

One of the most new interesting features that will be introduced by SQL Server 2016 is certainly the query store that will complete the performance tuning toolbox of database administrators. Basically, the query store will track queries, their query plans(…)

Oracle Cloud Service – my first outage

By Franck Pachot . We experienced the first planned outage this week-end, so let's see how it is notified and what happens.

You are in Standard Edition, when to worry?

By Franck Pachot . A previous blog post explaining what happens for those in 'Standard Edition One' had a "don't worry" in the title because you can upgrade to SE2 with minimal additional cost - except(…)

11.2.0.4 support? Don’t worry until 2017

By Franck Pachot . Customers reluctant to go to 12c before 12.2, in addition to Standard Edition contract changes when going to 12c, has lead to lot of upgrades to 11.2.0.4 but what about support? Don't worry. It's supported for(…)

SQL Server 2016: New possibilities for Index Maintenance Task

The new CTP 2.4 has been released some weeks ago by Microsoft. My colleagues and I have already blogged about some new functionalities. I will focus in this blog about the new possibility of Index Maintenance Tasks regarding Indexes. Until(…)

dbsnmp expiring password, manually triggering metrics collections

When you use Enterprise Manager Cloud control 12c, the monitor username commonly used is dbsnmp. Depending on the Oracle profile used for this user, the dbsnmp password can expire, and as a consequence multiple targets will be seen in a(…)

How to migrate your tablespace from 11g to a PDB in the Cloud

Goal We will take a tablespace named FOR TRAVEL for migrate it into a PDB situated in your Europe Cloud in extreme performance database. This migration will be executed with Data Pump and transportable tablespace method. We will migrate the(…)

How to be sure that tempdb size is good to run a DBCC CHECKDB?

In many blogs or forums, you can read that the answer is to use the option: WITH ESTIMATEONLY. With this option, you can easily have the space estimation needed to check the database in tempdb. But be careful, only since(…)

Mapping In-memory CU to values: IMCU pruning

By Franck Pachot . In the previous post we have seen how In-Memory Compression Unit map to the physical persistent storage - table extents. Let's see now how they are(…)

Mapping In-memory Column Store to datafile Row Store extents

By Franck Pachot . Oracle In-Memory is an hybrid solution: an In-Memory Column Store in addition to the traditional Row Store. In the IMCS, data is stored in IMCU (In-memory compression units) and metadata is in SMU (Snapshot Metadata Units)(…)