Oracle

Dbvisit Standby Archive Log Daemon

Dbvisit Standby version 8 comes with a nice feature, a daemon, which gives the benefit to send and apply the archive log automatically in the background. Bypassing the system scheduling, the daemon will facilitate customer RPO (Recovery Point Objective) and(…)

After IoT, IoP makes its way to the database

By Franck Pachot . At each new Oracle version, I like to check what’s new, not only from the documentation, but also from exposed internals. I look (and sometimes diff) on catalog views definitions, undocumented parameters, and even the(…)

sqlplus and its column output

During tuning or normal DBA activities one of the most annoying things is sqlplus with its default column output when running queries. I.e. even after setting a linesize of 1000 and a pagesize of 1000 the output may look as(…)

Docker: efficiently building images for large software

By Franck Pachot . I see increasing demand to build a Docker image for the Oracle Database. But the installation process for Oracle does not really fit the Docker way to install by layers: you need to unzip the distribution,(…)

Docker-CE on Oracle Enterprise Linux 7

By Franck Pachot . Here is how I install the latest Docker version on Oracle Linux 7. You find several blog posts about it which all install 'docker-engine'. But things move fast in this agile world and docker package name(…)

Result cache invalidation caused by DML locks

By Franck Pachot . In a previous post about Result Cache, I was using 'set autotrace on' in my session to see when the result cache hit saves the logical reads. I got a comment, by(…)

Connect-times to the DB suddenly become very slow using sqlcl

I recently wrote a couple of sql-scripts which had to run on all of my customer’s DBs. The sql-scripts had to be started from a Linux-client, which does not have any Oracle client software installed. So I thought of using(…)

18c PDB switchover

By Franck Pachot . In multitenant, the recovery and availability are at CDB level. But customers asked for a switchover at PDB level so Oracle has done that in 18c, based on refreshable PDBs. For this test I have two(…)

Enabled, Accepted, Fixed SQL Plan Baselines

By Franck Pachot . When the documentation is not always clear, I prefer to build a test case to be sure about the behavior in different context and different versions. Here is a test on SQL Plan Management to show(…)

ODA – Reducing number of cores : Getting error DCS-10045

To perform some tests in order to determine the accurate number of cores to be used by the database application, I had to increase and decrease the number of CPU cores on an ODA using the DCS stack.  When increasing(…)