Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner

Part I — Understanding Data Guard & High Availability 1.1  What Is High Availability, and Where Data Guard Fits High availability is the discipline of keeping a database reachable through failures …

Part I — Understanding the Upgrade 1.1  Why Upgrade from 11g to 19c Oracle Database 11g exited extended support years ago, which means no new security patches, no new bug fixes, …

Part I — Understanding the Building Blocks 1.1  Procedures and Functions A stored procedure is a named block of PL/SQL, compiled and stored inside the database, that performs an action. A …

Part I — Understanding Database Links 1.1  What Is a Database Link? A database link is a schema object that stores the connection details needed to reach another database, so that …

Part I — Understanding Database Health Checks 1.1  What Is a Database Health Check? A database health check is a structured review of an Oracle Database instance and its supporting infrastructure, …

Part I — Understanding Oracle APEX 1.1  What Is Oracle APEX? Oracle Application Express (APEX) is a low-code development platform built into every Oracle Database. It lets you design, build, and …

Part I — Understanding Oracle REST Data Services 1.1  What Is ORDS? Oracle REST Data Services (ORDS) is Oracle’s Java-based middle tier that lets applications and external clients access Oracle Database …

Part I — Understanding RMAN 1.1  What Is RMAN? Recovery Manager (RMAN) is Oracle’s built-in utility for backing up, restoring, and recovering Oracle databases. It ships with every installation of the …

Part I — Understanding Hire to Retire (H2R) 1.1  What Is H2R? Hire to Retire (H2R) is the standard ERP/HCM name for the complete employee lifecycle process from the moment a …