All articles

Parameterized Views with SYS_CONTEXT in Oracle. How can the optimizer peek values?

There was a dicsussion a couple of years ago about a mssing feature in Oracle that the Optimizer is not peeking values when SYS_CONTEXT is being used in a predicate. I.e. specifically when using SYS_CONTEXT in Views to simulate passing(…)

Patroni on FreeBSD 13?

You can already find several blog posts around PostgreSQL protected by Patroni on our blog. They all have in common, that the setup is on a flavor of Linux. As I got impressed by(…)

Use Ansible like a Programming Language

I did not intend to create a new blog on Ansible so fast, but here it comes. My previous blog on that topic was a first step in Ansible world. Now, it is time to use some of the(…)

Cloud CLI

By Franck Pachot . Here is how to quickly install the CLI (Command Line Interface) for the following public clouds: Amazon, Google, Microsoft and Oracle. On Linux, I’m using wget but you can use curl. I’ll install all cloud(…)

A web-based MBean Navigator for Oracle WebLogic wlst

Back in the days of WebLogic v8.x, when BEA still owned it and wlst wasn’t the official scripting tool yet, the unofficial wlshell and wlshell Explorer tools were available along with the official command-line tool weblogic.Admin. wlshell was a Windows(…)

JENKINS – recover access to your Jenkins Admin Dashboard

Hi team, I recently installed a Jenkins machine and forgot to create a “first admin user”, but I also forgot the password to log in with default admin user (I guess default password was admin but it doesn’t matter now(…)

Amazon RDS Oracle in Multitenant

By Franck Pachot . AWS has just added the possibility to create your oracle Database as as CDB (Container Database), the “new” architecture of Oracle where an instance can manage multiple databases, adding a new level between the heavy(…)

PostgreSQL on Oracle free tier ARM

By Franck Pachot . This follows the previous post about the Oracle Cloud ARM compute shape just announced on May 25th. The processor is ARM v8.2 with LSE (atomic instructions) and PostgreSQL can benefit from it (see(…)

An always free 4 vCPU 3.0 GHz 24 GB RAM on OCI

By Franck Pachot . Oracle Cloud free tier is already outstanding since OOW19 with two VMs and two databases that you can leave always running without any risk of being billed or seeing them stopped. I(…)

Automate restore from Rubrik with PowerShell

One of our customer uses Rubrik as a solution to recover, manage, and secure all their data. In this context, Rubrik is used to backup and restore all the SQL Server instances. We need to run restore tests(…)