All articles

Postgres vs. Oracle access paths IV – Order By and Index

By Franck Pachot . I realize that I'm talking about indexes in Oracle and Postgres, and didn't mention yet the best website you can find about indexes, with concepts and examples for all RDBMS: http://use-the-index-luke.com. You(…)

Encryption of shell scripts

In this blog, I will talk about the encryption of files and in particular the encryption of a shell script because that was my use case. Before starting, some people may say/think that you shouldn’t encrypt any scripts and I(…)

Documentum – Unable to install xCP 2.3 on a CS 7.3

Beginning of this year, we were doing our first silent installations of the new Documentum stack. I already created a few blogs to talk about some issues with CS 7.3 and xPlore 1.6. This time, I will talk about xCP(…)

Documentum – Using DA with Self-Signed SSL Certificate

A few years ago, I was working on a Documentum project and one of the tasks was to setup all components in SSL. I already published a lot of blogs on this subject but there is one I wanted to(…)

Developer GUI tools for PostgreSQL

There was a recent thread on the PostgreSQL general mailing list asking for GUI tools for PostgreSQL. This is question we get asked often at customers so I though it might be good idea to summarize(…)

Exadata Capacity on Demand and Elastic Rack

By Franck Pachot . Since X4 we can do Capacity on Demand on Exadata: disable some CPU cores to lower cost of Oracle Database licenses. Depending on the models, and the configuration, there are different minimums and here is a(…)

A wonderful PostgreSQL feature: default privileges

Imagine this scenario (which is not so uncommon): You have a lot of objects in a user schema and you want to grant another user access to that tables. You can easily do this by granting select(…)

Postgres vs. Oracle access paths III – Partial Index

By Franck Pachot . In the previous post I said that an Index Only Access needs to find all rows in the index. Here is a case where, with similar data, Postgres can find all rows(…)

Postgres vs. Oracle access paths II – Index Only Scan

By Franck Pachot . In the previous post I've explained a sequential scan by accident: my query needed only one column which was indexed, and I expected to read the index rather than the table. And(…)

Oracle Cloud: script to stop all PaaS services

By Franck Pachot . With metered cloud services, keeping all your instances running may become expensive. The goal is to start them only when you need them. Here is a script that stops all instances you have on the Oracle(…)