Enterprise content management Documentum – Unable to install xCP 2.3 on a CS 7.3 05.08.2017 by Morgan Patou 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(…)
Enterprise content management Documentum – Using DA with Self-Signed SSL Certificate 05.08.2017 by Morgan Patou 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(…)
Database Administration & Monitoring Developer GUI tools for PostgreSQL 04.08.2017 by Daniel Westermann 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(…)
Oracle Exadata Capacity on Demand and Elastic Rack 04.08.2017 by Oracle Team 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(…)
Database Administration & Monitoring A wonderful PostgreSQL feature: default privileges 04.08.2017 by Daniel Westermann 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(…)
Oracle, PostgreSQL Postgres vs. Oracle access paths III – Partial Index 03.08.2017 by Oracle Team 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(…)
Oracle, PostgreSQL Postgres vs. Oracle access paths II – Index Only Scan 02.08.2017 by Oracle Team 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(…)
Cloud, Oracle Oracle Cloud: script to stop all PaaS services 02.08.2017 by Oracle Team 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(…)
Oracle Display Data Guard configuration in SQL Developer 01.08.2017 by Oracle Team By Franck Pachot . The latest version of SQL Developer, the 17.2 one released after Q2 of 2017, has a new item in the DBA view showing the Data Guard configuration. This is the occasion to show how you can(…)
Oracle, PostgreSQL Postgres vs. Oracle access paths I – Seq Scan 01.08.2017 by Oracle Team By Franck Pachot . Here is the first test I've done for my Postgres vs. Oracle access paths series and the first query did a sequential scan. It illustrates the first constant you find in the(…)