Database Administration & Monitoring

Fixed table automatic statistic gathering in 12c

By Franck Pachot . Before 12c, the fixed stats statistics were not gathered automatically. In 12c this has changed: even when you have never gathered fixed objects statistics you can see that you have statistics for X$ tables. That may(…)

Créer une base Oracle sur le Cloud en quelques clicks

By Franck Pachot . Il n'a jamais été aussi facile de créer une base Oracle. Et ceci grâce au Database as a Service (DBaaS). C'est l'occasion de tester le cloud: Oracle Cloud Service offre une version d'essai de un mois.

Lost in the Cloud? My Cloud vs. My Services

By Franck Pachot . The Oracle Cloud has two interfaces that are very similar visually and it's easy to get lost and don't find what we are looking for in the menus.

Cloning a PDB to the Oracle Cloud Service

By Franck Pachot . When you create a DBaaS on the Oracle Cloud Service you have only one way to access to your database: ssh with the public rsa key you provide. Then you can open some ports to access(…)

Windows Server 2016: Introducing stretch cluster functionality

Let’s continue with the new high available functionality shipped with the next Windows version. In my previous blog, I talked about the new site awareness feature that provides more flexibility to configure failover resources priorities and(…)

How to check Multitenant Option feature usage

By Franck Pachot . Matching the Feature Usage Statistics to licensed options is not always easy. And once a feature usage is recorded, it is usually stored definitively. Let's see how the multitenant option is recorded there.

Install PL/JAVA in PostgreSQL 9.5.1

Some time ago I blogged about how to install PL/JAVA in Postgres Plus Advanced Server 9.5. This resulted in an interesting comment from the maintainer of PL/Java. After(…)

Configurer les “Bonnes Pratiques” de Windows Server avec PowerShell

PowerShell est un outil en ligne de commande dorénavant intégré à tous les environnements Windows. Cet outil est extrêmement puissant, et avec le vent en poupe, puisqu’il permet de simplifier l’exécution et l’automatisation des tâches de configuration et d’administration.

LVM : How to extend a Volume Group

In this article we’ll going to explore on how to extend a partition which resides in a Logical Volume. LVM (Logical Volume Manager) is a great tool for managing your storage devices on a Linux host. Lets(…)

Linux quick tip – What is the local time in Kolkata?

Quite easy if you know how to do it from the shell (I didn’t know it 🙂 ): dwe@dwe:~$ TZ='Asia/Kolkata' date Tue Mar 22 19:12:25 IST 2016 You can use “tzselect” to list the available combinations and get the local(…)