Database Administration & Monitoring

Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE

Sie haben es vielleicht noch nicht gesehen, aber mit den Service Pack 2 von SQL Server 2014 gibt es einen neuen DBCC Befehl: CLONEDATABASE. „DBCC CLONEDATABASE sollte Kopien eines Schemas und den Statistiken einer Produktionsdatenbank erstellen, um bei Leistungsproblemen Abfragen(…)

Generate Azure VM with Resource Manager deployment in PowerShell

Recently, there is a new way to manage the Azure infrastructure with Resource Manager. It brings many advantages regarding the classic deployment. The differences between these two deployments will not be covered in this blog because it is(…)

Unplugged pluggable databases

By Franck Pachot . When Oracle Multitenant came out in 12c, with pluggable databases, it was easy to draw them as USB sticks that you can plug and unplug to/from your Container Database (CDB). I don't like this because it(…)

Windows: Sauvegarde RMAN sur un disque partagé

Dans ce blog, je vais vous expliquer comment exporter les backups RMAN sur un « share disk » appartenant à un Domaine. Assurer la sécurité des données est l’une des tâches principales de l’administrateur : La mise en œuvre d’une protection des fichiers sensibles(…)

Multitenant internals: object links on fixed tables

By Franck Pachot . The previous post partly answered to the original question (why an object link to V$SESSION is refreshed only every 30 seconds): recursive queries on shared=object views. Now let's see what is different(…)

Multitenant internals: how object links are parsed/executed

By Franck Pachot . I had a comment on object links internals when creating a sharing=object view on GV$SESSION. Before posting about this specific case, I realized that I've never explained how a query on(…)

How to do a Filesystem Resize (ext3/ext4) on Redhat running on VMware

By William Sescu A filesystem resize can be done in several ways, online, offline, with LVM2 or without LVM2.  However, this blog will describe how to do an online resize of ext3/ext4 filesystems where a virtual disk (vmdk) is online(…)

SQL Server AlwaysOn: troubleshooting improvements with new service packs

As promised in my latest blog, I will talk about improvements in the detection of the availability group replication latency. As a reminder, replication latency between high(…)

Exadata X-5 Bare Metal vs. OVM load testing

By Franck Pachot . In a previous post I tried to compare a single thread workload between Exadata X5 Bare Metal and Virtualized. The conclusions were that there is no huge differences, and that this kind(…)

Oracle serializable is not serializable

By Franck Pachot . Did you know that when you set isolation level to SERIALIZABLE, it is not serializable but SNAPSHOT? This isolation level is lower than serializable. I've never thought about it until I read Markus Winand(…)