Browser-Based Audio Recording, Playback, and BLOB Storage Using JavaScript and PL/SQL Author: Zulqarnain HaiderTechnology: Oracle APEX 26.1, Oracle Database, JavaScript, HTML, CSS, PL/SQL 1. Introduction Audio recording is a useful …
Read More »Yearly Archives: 2026
Oracle Exadata Smart Scan & Storage Index
Oracle Exadata Smart Scan and Storage Index : How Engineered Storage Changes the Rules of Query Tuning : Introduction : Everything covered so far assumes a conventional storage architecture: the …
Read More »Oracle (RAC) Global Cache Tuning
Oracle Real Application Clusters (RAC) Global Cache Tuning : Introduction : Everything covered so far – blocking, deadlocks, ADDM, SPA, AWR Compare Periods, SQL Monitor, 10053, Database Replay, ASH – …
Read More »Implementing Two-Factor Authentication in Oracle APEX Using TOTP
A Practical Implementation Guide with User Registration, QR Code Enrollment, OTP Verification, and Custom Authentication Author: Zulqarnain HaiderApplication Name: Two-Factor Authentication DemoOracle APEX Export Release: 26.2.1Technology: Oracle APEX, Oracle Database, …
Read More »Oracle Active Session History (ASH): The Sampling Model for Transient Performance Problems
Oracle Active Session History (ASH) : The Sampling Model for Transient Performance Problems : Introduction : AWR and ADDM operate on snapshots. By default, AWR captures a snapshot once per …
Read More »Full-Scale Workload Testing for Changes and Migrations
Oracle Database Replay: Full-Scale Workload Testing for Changes and Migrations : Introduction : Every DBA eventually faces a change that is too risky to test with a handful of SQL …
Read More »Oracle 10053 Optimizer Trace
Oracle 10053 Optimizer Trace: Seeing Inside the Cost-Based Optimizer : Introduction : Every time Oracle performs a hard parse of a SQL statement, the Cost-Based Optimizer (CBO) goes through a …
Read More »Building a Conditional Workflow and Workflow Monitoring Console in Oracle APEX
A Practical Guide to Oracle APEX Workflow Automation, PL/SQL Activities, Workflow Variables, Conditional Branching, and Workflow Monitoring 1. Introduction Workflow automation is an important part of modern enterprise applications. Many …
Read More »Oracle SQL Monitor : Real Time Execution Plan Monitoring
Oracle SQL Monitor : Real Time Execution Plan Monitoring : Introduction : SQL Monitor is a diagnostics tool that tracks long-running SQL statements while they are still executing. It does …
Read More »Oracle AWR Compare Periods Report
Oracle AWR Compare Periods Report : Diagnosing Database Performance Degradation Β Introduction : AWR Compare Periods Report (officially “AWR Compare Periods”) is part of Oracle’s Diagnostics Pack. Its purpose is …
Read More »
Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner