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...