In September, Oracle ACEs from all around the world shared tips and tricks, insights, and knowledge in over 240 blog posts and articles. Let us highlight some of them for you to read and enjoy, focusing on 23ai, APEX, OCI, Linux, and more.

Alireza Kamrani
Assoc
  – A complete overview of performance tuning capabilities and features in Oracle Database

In this post, I presented some essential techniques for investigating and discovering performance issues in Oracle databases.

Anil Mahadev 
Pro
Build and Customize your own Oracle 23ai Docker Image and deploy customer containers

If you’re a developer or a database enthusiast looking to explore Oracle Database 23 AI capabilities, Docker provides an easy and flexible way to get started. Oracle 23 AI introduces powerful artificial intelligence features, and running it in a Docker container gives you the flexibility to test and experiment without needing a dedicated environment.

Bobby Curtis 
Director
Securing AI, LLMs, and Oracle Database 23ai

Since OpenAI released ChatGPT on November 30, 2022, there has been a growth in LLMs and AIs seemingly overnight. Between Microsoft’s and Oracle’s announcements of AI enabled applications, in 2023, followed by Google and Amazon; the industry has been buzzing about large language models (LLMs) and the use has skyrocketed across the industry. Leading many organizations and people asking how to secure an AI? What are the security implications?

Boyd Timmerman 
Assoc
Improve APEX Functionality Using Oracle Digital Assistant

During the recent NLOUG meetup, I gave a presentation on the integration of Oracle Digital Assistant (ODA) into an APEX application. The focus was on a problem faced by teachers at the Amsterdam University of Applied Sciences.

David Pabst 
Pro
& Sara Beth Good 
Pro
Let’s take a look at Oracle’s New Oracle Cloud EPM for Sustainability accelerator

Environmental social governance (ESG) and sustainability reporting is important when it comes to measuring the impact of an organization’s policies and procedures for a sustainable future. ESG reporting has an impact on an organization’s brand, revenue, company valuation, and market perception.

Fernando Simon 
Director
ExaCC, Upgrading from OEL 7 to OEL 8

Recently I shared several posts about the process to upgrade the GI from 19c to 23ai at ExaCC. My last post summarizes a lot of this, please read it here. But as you know, to use the 23ai you need to be running with OEL 8, and for ExaCC, the upgrade is quite simple.

Graham Smith
Director
OCI Resource Scheduler

This article explores a new feature in OCI called Resource Scheduler.  First released in May 2024, this is a long awaited and very welcome addition to the OCI service offering.

Hanno Embregts 
Pro
Java 23 Has Arrived, And It Brings a Truckload of Changes

Java 23 has arrived! It’s been six months since Java 22 was released, so it’s time for a fresh truckload of changes. This post takes you on a tour of everything that is part of this release, giving you a brief introduction to each of them.

Harish Vummidi 
Assoc
Enhance Your Learning Experience with Visible Activity Time for Available Offerings in Oracle Learning!

Oracle has rolled out an exciting new feature in the 24D version of the Oracle Learning module! Learners can now easily view the activity date, time, and timezone for any instructor-led or blended offering with a single instructor-led activity, right on the Available Offerings page.

Joel Acha 
Pro
The Oracle Analytics AI Assistant

Oracle Analytics have just announced the general availability of the AI Assistant. It is a new feature that allows users to interact with their data using natural language. This means you can ask questions in plain English and the assistant will generate visualisations and insights based on your dataset.

Johnny Cree 
Assoc
Improving Cost Efficiency Using FinOps and Oracle Cloud Infrastructure

I am sure that a lot of people in the IT world have heard the term FinOps – but what does it really mean? ‘fin’ short for finance and ‘ops’ short for operations; its combination is an IT governance framework that combines financial management, contract and software license management, sustainability and operational excellence with a focus on cloud technology to optimise spending.

Jon Dixon
Pro
APEX Background Page Processing – The Definitive Guide

Most enterprise applications have workloads that need to be run in the background. This is often a more efficient use of system resources and also allows users to continue working with your App while the processing takes place.

Martin Berger
Pro
Using Oracle Linux 8.10 in WSL for Oracle Cloud Infrastructure Ansible Collection

In this blog post, we will guide you through the process of setting up Oracle Linux 8.10 in Windows Subsystem for Linux (WSL) to effectively work with the Oracle Cloud Infrastructure (OCI) Ansible Collection. We’ll cover installation, necessary packages, OCI CLI setup, and a test of the setup. One of the great features of WSL is its seamless integration with Visual Studio Code (VS Code).

Nikhil Kotak 
Assoc
–  Mastering Memory Management in Oracle Database 23ai: An Overview of Unified Memory Management

 Memory management in Oracle Database is a critical aspect that influences the efficiency and performance of database operations. In Oracle Database, two primary memory structures—System Global Area (SGA) and Program Global Area (PGA)—need to be managed effectively. Oracle offers several methods for memory management, which can be configured through initialization parameters.

Philip Godfrey
Assoc
& Abi Giles-Haigh 
Director
–  A Pair of Aces: Journey from ACE Associate to ACE Director

You may have never heard of the Oracle ACE program, be a member already, or simply aspire to join the community and want to learn more, well this blog is for you.

Radu Pârvu 
Pro
Oracle Database: Constraints Tutorial

I will gather in this article several queries, code blocks that I use as a practician when managing constraints.This article will be updated periodically with new hints.

Roger Cornejo 
Director
Oracle Database 23ai Vector Search

The landscape of database technology is rapidly evolving, and Oracle Database 23ai’s introduction of vector search capabilities marks a pivotal moment for developers who have honed their skills within the realm of traditional relational databases.

Srinivasarao Ravulapalli 
Pro
How to Create Oracle 19C Dataguard Primary and Physical Standby Database step by step process part 1

In this post i will show you how to Create Oracle 19C Dataguard Primary and Physical Standby Database configuration step by step Process.

Tomasz ZIss 
Assoc
Oracle 23ai – Automate SecureFiles Shrink exercise

When I saw this option added in the latest version of the database – Oracle 23ai – my face immediately smiled. Why? I remembered how much trouble shrinking has always caused on LOBs (Large Objects – data types used in database to hold). Especially in systems where the DML operation time is of great importance.

Zoran Tica 
Pro
–  Oracle Database – case sensitive Columns/Components in PL/SQL Collections, Records and Objects

Regarding table and column names, Oracle is by default case insensitive. This means the table column can be named address or ADDRESS or AdDrEsS… it does not matter – the database converts all those lower/mixed case combinations into the upper case.

 

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!