All articles

An introduction into server side programming in PostgreSQL – 1 – SQL functions, basics

Over the last years I've seen many different applications running against PostgreSQL. The use cases vary from simple applications, which only use basic data types and a few tables and views, to complex applications with custom types, more specific data(…)

Learn ODA on Oracle Cloud

By Franck Pachot . You want to learn and practice your ODA command line and GUI without having an ODA at home? It should be possible to run the ODA image on VirtualBox but that’s probably a hard work(…)

Google Cloud SQL Insights: ASH, plans and statement tagging

By Franck Pachot . Looking at database performance has always been necessary to optimize the response time or throughput, but when it comes to public cloud where you are charged by resource usage, performance tuning is critical for cost(…)

19c serverless logon trigger

By Franck Pachot . I thought I already blogged about this but can’t find it. So here it is, with a funny title. I like to rename oracle features by their user point of view (they are usually named(…)

How long does it take to redeploy an ODA X8-2M?

Introduction One of the advantage of Oracle Database Appliance is its fast deployment. Most often, the initial setup of a lite ODA (with a reimaging) only takes half a day, from unboxing until a first test database is available. Trust(…)

JENKINS Quick overview on Jenkins and Jenkins X

Hi everybody, During previous blog ,we ever talked about Jenkins , but what about Jenkins X ?What are the differences between the two, which one is fitting the best for your needs? History of Jenkins X As the(…)

Oracle 21c: Blockchain Tables

Oracle Blockchain Tables With Oracle Database 20c/21c the new feature Oracle Blockchain Tables has been introduced. Blockchain Tables enable Oracle Database users to create tamper-resistant data management without distributing a ledger across multiple parties. Database security can be improved by(…)

Pressure Stall Information on Autonomous Linux

By Franck Pachot . The Linux metrics that are usually considered for performance monitoring and troubleshooting have many drawbacks and frequent misinterpretations. The recent kernels provide PSI (Pressure Stall Information) which is not enabled by default in Oracle Linux(…)

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(…)