All articles

Dbvisit replicate – SQL Developer chart

By Franck Pachot . Here is a quick SQL Developer report which display a chart about the Dbvisit replicate lag over the last hours(…)

Are temporary tables auto vacuumed in PostgreSQL?

While doing the EDB quiz at their booth last week at pgconfeu one of the questions was: Are temporary tables auto vacuumed? What do you think? My first thought was yes, but lets see. The first question(…)

Configuring Fusion Middleware 12C Reports Server with Single Sign On and External LDAP server

Most of the time when the Reports Server is configured with an Single Sign On Server, it uses the same external LDAP server as the Single Sign On Server. In our case, we used an Oracle Access Manager as(…)

New installed Fusion Middleware 12C Reports or Forms WebLogic Servers fails to start after configuring SSL

We installed a Fusion Middleware report and Forms 12.2.1.2.0 on a Linux Server. This was a single node Reports and Forms servers. After disabling the Non SSL Listen Port, we get below error in logs while starting the(…)

Max PDBs in Standard Edition

By Franck Pachot . Here is a small warning. In Standard Edition, you may expect that the features that are not available for your edition are blocked, but in 12.2 you can create more than one PDB in Standard Edition,(…)

StandbyFileManagement is set to MANUAL : Don’t panic

By Mouhamadou Diaw As you may know the parameter STANDBY_FILE_MANAGEMENT enables or disables automatic standby file management. When automatic standby file management is enabled, operating system file additions and deletions on the primary database are replicated on the standby database.

Database is more than persistence. It is shared. My thoughts about Microservice Database.

By Franck Pachot . The development teams often see the database as a 'persistence layer' only. And sometimes it is mentioned that the database is always the cause of the problems, especially when implementing continuous integration and trying to be(…)

Archivelog deletion policy on Data Guard configuration

By Franck Pachot . The deletion policy on a dataguard configuration should be: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; for the site where you don't backup. It can be the standby or the primary. and: CONFIGURE ARCHIVELOG(…)

VirtualBox 5.2 exports the VM to the Oracle Cloud

By Franck Pachot . The new release of Oracle VM VirtualBox (aka VirtualBox) is there with a new functionality to export a VM to the Oracle Cloud Compute (aka Oracle Cloud Infrastructure). That can be interesting(…)

PostgreSQL Index Suggestion With Powa

By Mouhamadou Diaw A few time ago my colleague Daniel did a blog about POWA. In a nice article he shown how this tool can be used to monitor our PostgreSQL. In this present(…)