Blog: Oracle Database (3)

Troubleshoot ODA Repo Issue

Introduction ODA virtualized upgrades are always challenging, with unexpected issues often arising. One consistent problem I've noticed in upgrades up to version 18.8.0.0 is the..

Read More

Securing Your Oracle Database: Step-by-Step Guide to Configuring and Using DBSAT

Oracle Database Security Assessment Tool (DBSAT) is a popular command-line tool that helps identify areas where your database configuration, operation, or implementation..

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

How to Chat with MySQL Database in Natural Language (English)

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

Start of Advanced Queue Job Hanging in Oracle 19c

Oracle Advanced Queuing (AQ) is a database-integrated messaging infrastructure in the Oracle Database. AQ leverages the functionality of the Oracle database to store messages in..

Read More

Measuring Storage Performance for Oracle Database

Introduction Storage vendors often provide extensive product performance data, but this information may not accurately predict how the storage will perform with an Oracle..

Read More

Exadata Exascale and What it Means for Your Oracle Workloads

Last week, Oracle Exadata Exascale was released, and it is one of the features that I have been most excited about in a while. I will be writing a couple of blogs around the..

Read More

Oracle Database 23ai: Fetch Top-N Rows Per Group Queries

Overview: Oracle 23ai introduces partition by clause in fetch first clause to get top-N rows per group. A query’s syntax SELECT …….. FROM …….. ORDER BY , FETCH FIRST , ROWS ONLY..

Read More