All articles

Representing ranges with one data type?

How many applications do you know that need to define a validity of a row? And how many of these do that by adding two columns: valid_from and valid_to or similar column names? Well, in PostgreSQL (you already suspect it(…)

SQL Server Tips: Logical names don’t match with physical files names

During a copy of a database from an environment to another (from Production to pre-production for instance), people usually don’t changed the logical name of the data or log files when they rename the database and the physical file names.

Oracle Database Cloud Service – DBaaS

By Franck Pachot . My first trial was not very good because I had access to Schema as a Service only. Which is not new. But Oracle Cloud Services is becoming(…)

Configure the Resource Manager with SQL Developer

By Franck Pachot . Yes, the topics for the OCM 12c upgrade are online and I'm already looking at the topics. I'm talking about the 'Configure the Resource Manager' one here. Configuring Resource Manager in commandline(…)

DataGuard broker properties – Part II: log shipping parameters

By Franck Pachot . In the part I we have seen the properties that are imported when you add a database to the configuration, and which are then managed by the(…)

OCM 12c preparation: Materialized View explain_rewrite

By Franck Pachot . When I passed the OCM 11g exam, I had to prepare the 'Manage Materialized Views to improve rewrite' topic. Now that I'm preparing the 12c upgrade I checked quickly what I've(…)

DataGuard broker properties – Part I: imported parameters

By Franck Pachot . When you are using the DataGuard Broker, you should always use the broker (with DGMGRL or OEM) to change the parameters that are managed, rather than changing them with ALTER SYSTEM. But do you know which(…)

Connecting your PostgreSQL instance to an Oracle database – The PostgreSQL 9.5 way

As you might know PostgreSQL 9.5 is currently in alpha 2. One of the new features will be the possibility to import foreign schemas. Having this it is no longer required to create all the foreign(…)

MySQL FATAL: error 1040: Too many connections & 1135 Can’t create a new thread

Hi folks, Some of you probably already got error 1040 by playing with sysbench for instance and multiplying the number of MySQL threads. Documentation and blogs usually simply state that you have to increase the number of max_connections and the(…)

Connecting your PostgreSQL instance to an Oracle database

For integrating data from other systems PostgreSQL has the concept of foreign data wrappers. Many of these exist for different types of systems. In this post I’ll look into how you may connect PostgreSQL to Oracle. The(…)