26ai_en Does Patching Oracle GoldenGate 23ai Make it “26ai”? Latest Update Procedures
When applying the latest patches to Oracle GoldenGate 23ai (OGG 23ai), we have confirmed that the notation in the GUI an...
oracle database
26ai_en 26ai_en Oracle Data Guard Overview and Benefits: Basics of Disaster Recovery and High Availability
Oracle Data Guard provides the highest level of availability for Oracle Database. In this article, we will explain the o...
26ai Oracle 26ai Data Guard Broker Setup Procedure [OL8]
This article explains the complete procedure for building a High Availability (HA) configuration using Data Guard Broker...
26ai_en Oracle 26ai RAC PDB Creation and Deletion: Complete Step-by-Step Guide
Operating PDBs in an Oracle 26ai RAC environment requires not only SQL execution but also resource registration with srv...
26ai_en Oracle RAC 26ai PDB srvctl Management Guide: New Standards for PDB Start/Stop
Starting with Oracle Database 21c, it has become possible to control Pluggable Databases (PDBs) directly using the srvct...
26ai_en Oracle 26ai RAC Setup Procedure ② [DB / Database]
Once the construction of Oracle Grid Infrastructure (GI) is complete, the next step is the construction of the Oracle 26...
26ai_en Oracle 26ai RAC Setup Procedure ① 【GI・Grid Infrastructure】
Do you want to build the latest version of Oracle Database, Oracle 26ai Real Application Clusters (Oracle RAC), but find...
English NTP Server (Chrony) Setup Guide for Oracle RAC Construction
In an Oracle Real Application Clusters (Oracle RAC) environment, ensuring that the time on all nodes is accurately synch...
English DNS Server Setup Guide for Oracle RAC Construction (Full Version)
This document explains the procedure for constructing a DNS server and configuring clients to meet the requirements of O...
English How to Use the Oracle SQL TRUNCATE Statement: Differences from DELETE and Optimization
When deleting large amounts of data, have you ever experienced issues like "the process never finishes" or "the UNDO tab...
English Oracle SQL: Correct Way to Write Joins for 3 or More Tables and Non-Equi Joins
In business system development and data analysis, there are frequent scenarios where you need to retrieve information by...
English Oracle SQL: Enhancing DML with Subqueries! INSERT/UPDATE/DELETE Usage Strategies
"I want to register data using search results from another table.""I want to update rows matching specific conditions ba...
26ai_en Oracle Smallfile vs Bigfile Differences and Best Practices: A DBA’s Operational Guide
In the physical design of an Oracle Database, the choice of tablespace management method directly impacts future scalabi...
26ai_en Oracle 26ai Tablespaces Default to Bigfile? Verification and Precautions
In Oracle Database 26ai (version 23.26.1 and later), the latest release for 2026, Oracle 26ai tablespaces are configured...
English Oracle SQL Set Operators: How to Use UNION ALL, MINUS, and More
Have you ever wanted to compile data scattered across multiple tables into a single list, or compare two datasets to ext...
26ai_en How to Verify Applied Patches in Oracle 26ai: The Reality of the Latest RU 23.26.1.0.0
In January 2026, the long-awaited Oracle Database 26ai installer was released. To fully leverage the latest AI capabilit...
English Oracle SQL Non-Scalar Subqueries: How to Handle Multiple Rows and Columns
When extracting complex data with SQL, "subqueries" are unavoidable. However, do you struggle with the error "single-row...
English Introduction to Oracle SQL Subqueries! From Basics to Speed Optimization
Do you ever struggle when writing SQL, thinking "I want to use the result of another aggregation in a condition" or "I w...
English Oracle SQL Scalar Subqueries: From Basics to Optimization Strategies
When extracting data with SQL, do you ever struggle with requirements like "I want to fetch just one value from another ...
26ai_en Oracle Database 26ai Complete Deletion Guide: How to Use the deinstall Command
Are you looking for a safe and reliable way to uninstall Oracle? Manual deletion using rm -rf can leave configuration fi...