Skip to Main Content
Monitor Oracle APEX Applications with OCI Monitoring Custom Metrics

About This Workshop

Youtube Video

About This Workshop
Author: Adrian Png, Senior Cloud Solutions Architect, Insum Solutions Inc.

Service metrics provide administrators the ability to monitor the health and performance of many OCI services and resources. OCI Monitoring also administrator to publish custom metrics for special purposes such as monitoring the state of an application deployed on an OCI Compute instance. Custom metrics are sent to a special OCI REST endpoint that ingests telemetric data.

In this workshop, we will publish a custom metric that monitors the number of failed user logins to an Oracle APEX application. We will query an Oracle APEX view that logs user access, and then post the data to the REST endpoint using the PL/SQL package APEX_WEB_SERVICE. This code will be executed using Automations, a feature of Oracle APEX that allows developers to schedule and perform actions based on specific triggers and conditions.

Workshop Info

1 hour
  • Lab 1: Create OCI Identity and Access Management Resources
  • Lab 2: Setup an Oracle APEX Development Environment
  • Lab 3: Create an Oracle APEX Automation to Publish Custom Metrics
  • Lab 4: Create an OCI Alarm and Notification to Alert Administrators
  • Access to an Oracle Cloud tenancy.
  • Basic knowledge of Oracle APEX and PL/SQL development.
  • Familiarity with Oracle Cloud Infrastructure (OCI), especially with the observability and management services, is helpful.

 

Other Workshops you might like