All articles

Oracle 21c Security : ORA_STIG_PROFILE and ORA_CIS_PROFILE

By Mouhamadou Diaw In my previous blog I was testing the creation of a new Oracle 21c database. In this blog I am talking about two changes about the security. In each new(…)

A Simple Repository Browser Utility

A few weeks ago, as the final steps of a cloning procedure, I wanted to check if the cloned repository was OK. One of the tests was to peek and poke around in the repository and try to access its(…)

Oracle 21c : Create a New Database

By Mouhamadou Diaw Oracle 21c is now released on the cloud. And in this blog I am just testing my first database creation . As earlier release dbca is still present. Just launch it 1 [oracle@oraadserver admin]$ dbca(…)

JENKINS install Jenkins on Windows

Hi Team, Today let’s talk about Jenkins software What is Jenkins? Jenkins is an open source automation server that enables developers around the world to reliably build, test, and deploy their software.It is the leading open-source continuous integration server.

A typical ODA project (and why I love Oracle Database Appliance)

Introduction You can say everything about Oracle infrastructure possibilities but nothing compares to experience based on the realization of real projects. I did quite a lot of ODA projects during the past years (on other platforms too), and I would(…)

Aurora Serverless v2 (preview) – CPU

By Franck Pachot . This follows my previous post https://www.dbi-services.com/blog/aurora-serverless-v2-ram/ ‎which you should read before this one. I was looking at the auto-scaling of RAM and it is now time to look at the CPU(…)

Aurora Serverless v2 (preview) – RAM

By Franck Pachot . What is Aurora Serverless? That’s the RDS Aurora name for auto-scaling: instead of provisioning an instance size (from the burstable db.t3.small with 2 vCPU and 2GB RAM to db.r5.16xlarge with 64 vCPU and 512 GB(…)

Incremental materialized view maintenance for PostgreSQL 14?

Since PostgreSQL 9.3 there is the possibility to create materialized views in PostgreSQL. PostgreSQL 9.4 (one year later) brought concurrent refresh which already is a major step forward as this allowed querying(…)

Even faster data loading with PostgreSQL 14? wal_level=none

PostgreSQL is already very fast with loading loading large amounts of data. You can follow this post to get some recommendations for loading data as fast as possible. In addition you can create(…)

Database announcements at re:Invent 2020

By Franck Pachot . This year is not very nice for conferences as everything is virtual and we miss the most important: meeting and sharing with people. But the AWS re:Invent is actually a great experience. As an AWS(…)