Blog

Latest Posts

Oracle 23ai: True Cache

Introduction In today’s fast-paced digital landscape, speed is paramount. Users expect instant responses, and applications must seamlessly handle high traffic and demanding..

Read More

How to Configure Gen AI Service in Oracle APEX using Open AI

In this blog post, I will explain how we can configure the Gen AI service of Oracle APEX using the Open AI LLM model.

Read More

How to Chat with Oracle 23ai using SQL Agent

Introduction: In this blog post, I am going to build a simple chatbot where we can interact with the Oracle 23ai database.

Read More

Oracle 23ai: Lock Free Reservations Capability

Overview: In previous database releases when a column value of a row is updated by adding or subtracting from it, all other updates to that row are blocked until the transaction..

Read More

Oracle 23ai: Unrestricted Parallel DMLs

Overview: Oracle database allows DML statements to be executed in parallel mode by breaking the DML statements into exclusive smaller tasks. However, in releases prior to Oracle..

Read More

Set up DELTA (DB Endpoint Latency Testing Ammeter) to Test the Latency from a Windows System using venv to an Oracle Database

What is the DELTA? DELTA (DB Endpoint Latency Testing Ammeter) is a tool or framework designed to measure the latency of database endpoints. It is used to assess the performance..

Read More

Migration of On-Premises Oracle 18c PDB to OCI 19c PDB using Full Transportable Tablespace

Introduction Migrating an Oracle database from on-premises to Oracle Cloud Infrastructure (OCI) involves several steps to ensure a smooth transition while minimizing downtime. The..

Read More

How to Automate Start and Stop of DBCS Node using REST API in OCI

Recently we migrated databases from ODA (Oracle Database Appliance) to OCI DBCS for a client. And client asking to stop the dev DBCS node from 5 PM to 6 AM to save cost.

Read More

Maximizing Database Security: Unified Auditing Housekeeping Guide

Introduction Data is the new currency. It is one of the most valuable organizational assets, however, if that data is not well protected, it can quickly become a liability. At an..

Read More