During the month of August, Oracle ACEs from all around the world shared tips and tricks, insights, and knowledge in over 250 blog posts and articles. Let us highlight some of them for you to read and enjoy, focusing on 23ai, OCI, JSON, GoldenGate, TrueCache, Visual Builder, APEX, and more.

Ahmed Abdel Fattah – utltz_upg_apply script hangs while shutting down the Oracle Database

I was upgrading one Oracle Database from 12.2.0.1 to 19.23 on Windows platform manually.

 

Alex Rabinovich – Fusion SaaS: Perform efficient SQL validation for incoming files by using Custom Object CLOB fields, OIC and BIP

Importing external files into Oracle Fusion SaaS is a common requirement. Oracle provides HDL and FBDI that perform efficient pre-validations on input files before loading them to the system.

 

Alireza Kamrani – An Overview in Oracle 23ai Memory Management 

The memory structures that must be managed are the system global area (SGA) and the instance program global area (instance PGA). Oracle Database supports various memory management methods, which are chosen by initialization parameter settings.

 

Amod Joshi – Understanding the Data Flow Process in Oracle Cloud Infrastructure (OCI) Data Integration

In today’s data-driven world businesses need robust solutions to manage, process, and analyze vast amounts of data efficiently. Oracle Cloud Infrastructure (OCI) Data Integration is a powerful service designed to address these needs. With OCI Data Integration, (OCI-DI) organizations can seamlessly integrate data across various sources, load and transform it into meaningful insights, and drive informed decision-making.

 

Anas Darkal – Oracle 23ai: JSON Schema Support

Oracle first introduced the ability to display a JSON schema when they introduced the JSON Data in Oracle 12.2, but without the option to validate the structure of JSON document.

 

Andrej Pashchenko – SQL Macros – Changing The Query Shape Using Parameters?

One thing I learned early on when I was getting to know SQL macros is that we cannot replace each and every part of a SQL statement with a macro. In the same way, working with table SQL macros, we cannot represent just any part of the result string by referencing parameters inside it. Sometimes we need to use string concatenation.

 

Anil Mahadev – Introduction to Oracle Cloud: A Comprehensive Guide

Oracle Cloud is a comprehensive cloud computing platform that provides a wide range of services, including infrastructure, platform, and software as a service (IaaS, PaaS, and SaaS).

 

Bobby Curtis – Is your Oracle GoldenGate healthy?

With Oracle GoldenGate shifting to a “microservices” architecture, this allows Oracle flexibility to add new functionality without needing a complete new release.

 

Carla Muñoz López – Correo diario, semanal o mensual con resumen de los errores en el alert.log de Oracle

Como DBA, estar al tanto del alert log de Oracle es crucial para mantener la salud y el rendimiento de la base de datos. Sin embargo, revisar manualmente el alert puede ser tedioso y consumir tiempo valioso.

 

Chanaka Dinu Handurugama Yapa – Oracle 23ai : True Cache 

In today’s fast-paced digital landscape, speed is paramount. Users expect instant responses, and applications must seamlessly handle high traffic and demanding workloads. Oracle databases, often the backbone of critical systems, bear the weight of these performance demands.

 

Clarisa Maman Orfali  – IA Generativa: Usando el Asistente de APEX

En esta nueva versión de Oracle APEX 24.1 podemos utilizar la capacidad de chat de la inteligencia artificial integrada (llamada Asistente APEX) en los editores de código dentro del Creador de Aplicaciones.

 

César Carvalho – How to clone a local PDB

Oracle Multitenant has been present in our lives for quite some time now, this architecture helps us to consolidate multiple databases as PDBs into one CDB.

 

Fernando Simon – Manually upgrading Oracle GI from 19c to 23ai

With the official release of Oracle 23ai to Exadata on-prem, it is now possible to manually upgrade Grid Infrastructure (GI) from 19c to 23ai.

 

Gurpreet Singh – Creating Oracle Visual Builder Cloud Service (VBCS) instance?

Oracle Visual Builder Cloud Service (VBCS) is a cloud-based development platform that allows developers to rapidly create and deploy web and mobile applications with a low-code approach.

 

Harish Vummidi – Discover the New Redwood Quick Actions in Oracle Fusion Cloud HCM 24B

The latest 24B version of Oracle Fusion Cloud HCM brings a fantastic new feature to make your life easier: Redwood Quick Actions. Let’s dive into what this new feature offers and how it can simplify your workflow.

 

Johannes Michler – Running Oracle SOA Suite on Docker – Part 6: Patching

Operating – installing and maintaining – Oracle Fusion Middleware, especially Oracle SOA Suite 12.2.1.4 is quite some work. Not only does installation itself consist of a number of steps, but each quarterly critical patch update also requires applying a number of patches and – especially in simple, single server environments quite some downtime.

 

John Whitaker – Maximize insights in Oracle Analytics Cloud with Data Lakehouses Part 1 – The Data Lake

The variety, velocity, and volume of data have increased dramatically over the last twenty-plus years. The Data Lake was the architectural answer to address this evolving data landscape.

 

José Manuel Preda Rabello – Notificaciones Push PWA en Oracle APEX

Las notificaciones push PWA (Progresive Web App) en Oracle APEX son mensajes instantáneos que pueden ser enviados a los usuarios de una aplicación web progresiva sin que estos tengan que estar activamente utilizando la aplicación en ese momento.

 

Lech Cieślik – WMS, Map Backgrounds and Oracle APEX

Geospatial data plays an essential role in various fields such as urban planning, environmental monitoring, and logistics. One of the most widely used methods for serving geospatial data as maps over the web is the Web Map Service (WMS).

 

Lucas Hirschegger – Oracle APEX – Post-it Notes with Card Report

I’ve set myself a challenge today: creating a visually appealing post-it notes report in Oracle APEX with minimal coding.

 

Manoj Kumar – How to configure Gen AI service in Oracle APEX using Open AI

In this Blog post I will explian how we can configure Gen AI service of Oracle APEX using Open AI LLM model.

 

Martin Berger – Oracle Cloud Infrastructure – Cleanup Vulnerability Scan Reports

Sometimes it’s hard to cleanup old unused compartments. There are a lot of resources still available, and some of them like the CSS scans from Vulnerability Scanning are not visible in Oracle Cloud Infrastructure console.

 

Matt Mulvaney – Sorting in APEX: Classic Reports and Card Regions Explained

In this blog I’m going to Deep Dive in to Classic Report sorting, what it is, how it works including all the options for both users and developers.

 

Neil Chandler – Oracle Data Migration Validation

Data migration is common. Moving data from one database to another, either via Datapump, Goldengate, unload/load scripts or some other method has risk. 

 

Osama Mustafa  – Building a Scalable Data Pipeline on OCI with Data Flow

In this blog, we will explore how to build a scalable data pipeline on Oracle Cloud Infrastructure (OCI) using OCI Data Flow. We’ll cover the end-to-end process, from setting up OCI Data Flow to processing large datasets, and integrating with other OCI services.

 

Paul Guerin – Your next OCI compute instance managed from Virtualbox

Virtualbox adds another dimension to your virtual machines — on-prem or in the Oracle cloud.

 

Roger Cornejo – Introduction to SQL Insights: Understanding Execution Plan Changes

SQL execution plans are automatically generated by the Oracle optimizer and dictate how efficiently SQL statements are executed. In many Oracle databases, plan changes are common; the optimizer is designed to explore various execution plans to find the most efficient one.

 

Takayuki Nishio – What do I need to know when building an Oracle Database in a cloud environment?

株式会社第一コンピュータリソース 西尾孝之氏への紙上インタビュー、第二弾をお届けします。西尾氏はORACLE MASTER Platinum DBA 2019に一番乗りで合格され、Oracle Cloud Infrastructure Architect Professional 2022をはじめとして多くの資格を取得されています。

 

Timothy Hall – Oracle Database 23ai Free (23.5)

There have been a couple of posts about the latest release of Oracle Database 23ai Free.

 

Tomasz Ziss – Oracle 23ai – Database Sharding New Features

Database sharding. This architecture, based on the shared architecture model, already exists in Oracle for several years. From an application point of view, a sharding database with distributed shards on multiple hosts is always one database. From a database administrator’s perspective – not anymore. Multiple database hosts, organized as one entity.

 

Žiga Vaupot – Practical Guide to Load Large CSV Files to Oracle

Sometimes you need to be practical and apply some tricks to get the job done instead of waiting for the perfect tool. With SQL Developer Command Line you can load CSV with millions of lines with not too much hassle.

 

You can find all the ACEs above and many more on the Oracle ACE Directory. Bookmark the Oracle ACE Program blog and come back next month for more updates!