All articles

Handling unified auditing spillover files on the standby-site

Switching to Oracle Unified Auditing may produce lots of data when e.g. auditing activities of the SYS-user. I.e. according the documentation you can do the following to audit similarly as in traditional auditing with audit_sys_operations=TRUE: SQL> CREATE AUDIT POLICY TOPLEVEL_ACTIONS(…)

JENKINS Add new users on Jenkins

Hello everybody , today we will see how to manage user creation on Jenkins As many other scheduling software, Jenkins has tool to manage credentials and also grant access to users. Best practice to manage user right level is(…)

Dealing with German “Umlaute” in PostgreSQL’s full text search

PostgreSQL comes with build-in Full Text Search and you can do quite amazing stuff with it. A question that popped up during one of the last PostgreSQL for developers workshop was: How(…)

JENKINS Add plugins in Jenkins

Hi everybody, First of all,I wish you a happy new year with lot of success for all of you 😀 Now ,to have a good start for 2021 we will learn how to use one of the most important(…)

How to quickly download the new bunch of 21c Oracle Database documentation?

Last month, Oracle released its new 21c version of the database documentation. At that time, I was looking for a quick mean to get all the books of this so-called 21c Innovation Release. I could remember I used a(…)

Google Spanner – SQL compatibility

By Franck Pachot . I have posted, a long time ago, about Google Spanner (inserting data and no decimal numeric data types) but many things have changed in this area. There(…)

DctmAPI.py revisited

2 years ago, I proposed a ctypes-based Documentum extension for python, DctmAPI.py. While it did the job, it was quite basic. For example, its select2dict() function, as inferred from its name, returned the documents from a dql query into(…)

Migrate Oracle Database 9.2.0.6 to Oracle 19c using GoldenGate

When a customer wanted to take the challenge to migrate an oracle database 9.2.0.6 (the prehistory in the Oracle world) to Oracle 19c using Oracle GodenGate, I saw more problems than add value for different reasons:  Oracle 9.2.0.6 database is(…)

Exoscale scaling up and down

In my previous Blog I had wrote about Swiss Cloud Provider: Exoscale. Read the Blog Today we will look little bit deeper in three subjects: Template & Template sharing Scaling up and down instances dbi(…)

Optimizer Statistics Gathering – pending and history

By Franck Pachot . This was initially posted to CERN Database blog on Wednesday, 12 September 2018 where it seems to be lost. Here is a copy thanks to web.archive.org Demo table I create a(…)