All articles

Windocks – a different way to use SQL Server on Docker

I spent some times to write blog posts about SQL Server on Docker since few months and you likely noticed it concerned mainly SQL Server on Linux. But what about SQL Server on Docker and Windows? If you take a(…)

Postgres, the fsync() issue, and ‘pgio’ (the SLOB method for PostgreSQL)

By Franck Pachot . That's a long blog post title, which is actually just a good pretext to play with Kevin Closson SLOB method for PostgreSQL: pgio I use the beta version of pgio here. If you want to read(…)

ADWC – System and session settings (DWCS lockdown profile)

By Franck Pachot . The Autonomous Data Warehouse Cloud service is a PaaS managed service where we have a PDB and an ADMIN user which has most of the system privileges. For example, we have the privilege to change initialization(…)

Adding a Documentum extension into python

Many years ago, out of frustration by the poorness of scripting tools in Documentum, I realized a Documentum binding for python using the distutils and I remember how easy and straightforward it had been, even for someone not really into(…)

Customizing PostgreSQL parameters in EDB containers in MiniShift/OpenShift

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. In the last two posts we deployed an EDB database container and two pgpool instances and then(…)

Scaling the EDB containers in MiniShift/OpenShift

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. When you followed the last post you should have two pgpool instances and one EDB Postgres instance running(…)

12c upuserxt.lst, upobjxt.lst & Oracle Maintained objects/users

By Franck Pachot . Mike Dietrich has blogged recently about upuserxt.lst and upobjxt.lst and how to query them with external table. The first time I've seen those '.lst' files, the default extension(…)

Configuring WebLogic Server 12.2.1.3 Diagnostics Framework policies and actions

Configure a Policy-action (new name for watch-notification) to send a JMX notification when the monitored WebLogic Server is having stuck threads or high memory usage. We will use a simple JMX notification listener program which can process WLDF JMX notifications.

PDB RMAN backups available after plugging in on a new CDB with Oracle 18c

With Oracle 18c, it is possible to use PDB rman backups created on the source CDB (they are called PREPLUGIN backups) when the PDB has been relocated to a target CDB. In my environment, my original CDB is DB18, with(…)

ADWC – connect from your premises

By Franck Pachot . In the previous post about the Autonomous Data Warehouse Service, I've run queries though the Machine Learning Notebooks. But you obviously want to connect to it from your premises, with SQL*Net.