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

    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

    Explore →

  • A Performance Dashboard for Apache Spark

    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

    Explore →

  • Testing web applications SSO with Keycloak

    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

    Explore →

  • Oracle VPD as a safeguard for DML

    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,

    Explore →

  • Minimal Oracle

    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

    Explore →

  • Memorable CERN Openlab Summer Internship

    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

    Explore →

  • Oracle Index compression for range scan on file names

    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

    Explore →

  • Oracle LIKE predicate and cardinality estimations

    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

    Explore →

  • JMX connection with SSL

    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

    Explore →

  • An .rpm to install Oracle Database 18c

    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

    Explore →