Database Administration & Monitoring

Stay tuned with kernel parameters

Why does the sysctl.conf value for swappiness on Oracle Linux 7.x not survive a reboot For a project I applied the dbi services best practices for Oracle databases. One of these is to adjust the swappiness parameter. We recommend to use(…)

Single-Tenant vs. non-CDB: no reason to refuse it

By Franck Pachot . When non-CDB has been declared deprecated, I was a bit upset because multitenant with a lone PDB just looks like an overhead of 3 containers instead of one. But with experience I changed my mind. First(…)

Oracle kernel relink on Linux: Are my options stored persistently?

I recently visited an Oracle presentation about the Oracle-kernel built-in directNFS (dNFS) driver. To use dNFS in the database you have to enable it: cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk dnfs_on REMARK: In versions before 11gR2/12c(…)

Maintenance scenarios with EDB Failover Manager (1) – Standby node

Recently at a customer we again implemented a PostgreSQL architecture as described some time ago. When we delivered the first draft of the documentation the question popped up how to handle maintenance tasks in a failover cluster(…)

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.