Tag: installation

  • ORDS – Managing APEX static images

    ORDS – Managing APEX static images

    ORDS – Managing APEX static images In today’s post, we’ll be talking about the possible ways to manage the static images/CSS/JS that come shipped with APEX, when running on ORDS. They are separate resources (not contained in the DB like some other APEX images) necessary for your APEX applications look and behave the way they’re

    Explore →

  • Oracle REST Data Services running on Tomcat – Basic Authentication using JNDI Realm

    Oracle REST Data Services running on Tomcat – Basic Authentication using JNDI Realm

    Oracle REST Data Services running on Tomcat – Basic Authentication using JNDI Realm What do we want to achieve? We want to protect our REST endpoints using Basic Authentication and authenticate the requests against our users directory (LDAP). We also want to manage the privileges centrally, through the ORDS Roles and Privileges (https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-authentication#ords-roles-and-privileges), so no

    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 →

  • 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 →

  • Linux BPF/bcc for Oracle Tracing

    Linux BPF/bcc for Oracle Tracing

    Linux BPF/bcc for Oracle Tracing Topic: In this post you will find a short discussion and pointers to the code of a few sample scripts that I have written using Linux BPF/bcc and uprobes for Oracle tracing. Previous work and motivations Tools for dynamic tracing are very useful for troubleshooting and internals investigations of Oracle

    Explore →

  • A Closer Look at CALIBRATE_IO

    A Closer Look at CALIBRATE_IO

    A Closer Look at CALIBRATE_IO Topic: This blog entry is about investigating Oracle’s DBMS_RESOURCE_MANAGER.CALIBRATE_IO Spoiler: For quantitative analysis of storage performance and in particular for measuring random read I/O in Oracle, I’d rather advise the use tools that allow generating test workloads in a controlled manner, in a way that can be understood and measured

    Explore →