Category: Blog Post
-

Keeping your logs clean with Apache Tomcat 9, log4j2 and spring-boot
Keeping your logs clean with Apache Tomcat 9, log4j2 and spring-boot These last days I’ve been playing with Apache Tomcat 9 and log4j2. You may wonder why I want to change the good an old Tomcat JULI. Well, although I love the simplicity of its configuration and the fact that JULI works, log4j2 offers a
-

A Performance Dashboard for Apache Spark
A Performance Dashboard for Apache Spark Topic: This post dives into the steps for deploying a performance dashboard for Apache Spark, using Spark metrics system instrumentation, InfluxDB and Grafana. What problem does it solve: The dashboard can provide important insights for performance troubleshooting and online monitoring of Apache Spark workloads. In particular when running Spark
-

Testing web applications SSO with Keycloak
Testing web applications SSO with Keycloak Usually when you are developing a new feature or fixing an issue, you want to focus in your business logic. If your application delegates the authentication in some SSO system you usually mocks the response from this last one. However for integration tests, it is nice to be able
-

Oracle VPD as a safeguard for DML
Oracle VPD as a safeguard for DML Virtual Private Databases (VPD) is an Enterprise Edition feature related to security. It restricts the scope of Data Manipulation Language to a subset of the table rows by transparently adding a where clause before executing them. It is also called Row-Level Security (RLS). Where the policy is enabled,
-

Minimal Oracle
Minimal Oracle The Oracle Database software is large, several gigabytes in Oracle Home for the part that is deployed on the operating system, and additional megabytes in SYSTEM tablespace for the part that is deployed as stored procedures (mainly the dbms_% packages). And this is not a problem with the traditional deployment methods where you
-

Memorable CERN Openlab Summer Internship
Memorable CERN Openlab Summer Internship In this post, I will be talking about my openlab project and internship experience. CERN Openlab Summer Project: Achieve a 0-downtime CERN Database infrastructure My project was about evaluating, comparing and testing Oracle Ksplice with Red Hat Kpatch. With the rate at which security vulnerabilities are discovered these days, keeping
-

Oracle Index compression for range scan on file names
Oracle Index compression for range scan on file names Do you have tables with a column storing filenames? Long filenames with full path? If this is the case, then you probably realized how an index on this can be large. And when looking at the values sorted, you have seen the inefficiency of it: a
-

Oracle LIKE predicate and cardinality estimations
Oracle LIKE predicate and cardinality estimations There are not many ways to access efficiently to table rows. Either you want lot of them, because your predicate is not very selective, and you read the whole table in the fastest you can do. This is Table Full Scan. Or you use a structure that gives you
-

JMX connection with SSL
JMX connection with SSL General description For developers it is a huge help if they have an application insight possibility and can check out whats going on under the hood on a production or test environment. JAVA allows to monitor remotely the Java Virtual Machine (JVM) itself with client applications like JConsole, JAVA Mission Control
-

An .rpm to install Oracle Database 18c
An .rpm to install Oracle Database 18c It was announced at Oracle Open World 2017 and here it is just before the start of OOW18: an RPM to install the Oracle Database software. Download In the Oracle Database 18c download page there are two files for 18.3. One is a zip of the Oracle Home