Throughout July, Oracle ACEs from all around the world shared tips and tricks, insights, and knowledge in over 300 blog posts. Let us highlight some of them for you to read and enjoy, focusing on 23ai, Vector search, APEX, OCI, AHF, and much more.

Andreas Buckenhofer 
Associate
Oracle AI Vector – Semantic Search

With the advent of Large Language Models (LLM), vector databases are becoming increasingly popular. Vector databases and similar approaches have existed for a long time such as geodata have long been established. Oracle offers since Oracle Database 23ai vector functionalities and further enriches the concept of a converged database. This article looks at similarity search and indexing for Oracle AI Vector.

Anil Mahadev 
Pro
Setting up Oracle 23ai FREE on Windows Server 2022 Azure Edition

In this quick blog post, we shall go through the steps of setting up Oracle 23ai FREE on Windows Server 2022 Azure Edition.

Anton Nielsen 
Associate
Oracle APEX : Invoke an Ajax Callback Process

When I want to invoke a server side process from a dynamic action (DA), I have two choices:

  • Create a DA Action of type “Execute Server-side Code”
  • Create a DA Action of type “Execute Javascript Code” and then write the javascript to invoke an Ajax Callback process.

Dani Schnider 
director
Staging Tables in Oracle 23ai

Browsing through the Oracle 23ai New Features Guide, I once again discovered a small, inconspicuous feature that I had previously overlooked: There is a new option to create stage tables. What is the advantage of this enhancement?

Fernando Simon
director
23ai, orapwd and the format value

Recently I was playing with 23ai at ExaCC and got a strange error reporting format mismatch for the password file for my standby. Digging over it I saw that the orapwd has a different default value than dbca.

Harish Vummidi
Associate
Enhancements in Oracle HCM

With the upcoming 24D update, there’s an important change you need to be aware of regarding the Redwood Journey Template pages.

Johannes Michler
director
–  Running Oracle SOA Suite in Docker – Overview

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.

Jon Dixon
Pro
Dynamic Parameters in Oracle APEX REST Data Source Synchronizations

In this post, I will describe how to dynamically pass parameters to Oracle APEX Rest Data Source Synchronizations. APEX REST Source Synchronizations allow you to declaratively Sync data from a REST API to a local table.

Manoj Kumar
Associate
How to chat with MySQL database in Natural language

In this Gen AI world, companies are working hard to release best LLM model, few of them are OpenAI, Google, Meta, anthropic. Today I will show you how we can chat with our MySQL database using OpenAI LLM model. You can use any other model as well, even use any open source model.

Marc Wagner
Pro
Create new PDB in a Data Guard environment on ExaCC

In this blog, I would like to share how to create a new PDB in one CDB in a Data Guard environment on the ExaCC.

Mario Barduchi
Pro
–  [ORACLE] Quick tips: Autonomous Health Framework (AHF) files cleanup

Hello everyone. How are you doing? Today, I going to show you a quick tip about the AHF – Autonomous Health Framework. In case your autopurge is off, and your disk space is slowing, you can do a manual purge.

Matt Mulvaney
director
What exactly is the APEX Validations by Page Report?

In this Blog, I’m going to explore the APEX Validations by Page Report. On the surface it appears as a valuable utility which allows developers to assess whether Page Items have the correct assignment of APEX Validations.

Osama Mustafa
Pro
Implementing Data Replication and Disaster Recovery with OCI Autonomous Database

Overview of OCI Autonomous Database and its capabilities. Importance of data replication and disaster recovery for business continuity.

Paul Lewis
Pro
EPM August 2024 Updates

Here are the updates for August 2024. There are no updates to Planning, but there are a few for EPM Cloud Platform. There are also a couple to Enterprise Profitability and Cost Management worth a look.

Philip Godfrey
Associate
Data In, Insights Out: Data Flows Made Easy in Oracle Analytics Cloud

Oracle Analytics Cloud is a powerful tool that enables organizations to make data-driven decisions by providing advanced analytics capabilities.

Srinivasarao Ravulapalli
Pro
Oracle Apps DBA Workflow Mailer Tips

In this post will share couple of Workflow mailer related information as part of Oracle Apps DBA Job.

Tomasz Ziss
Associate
Oracle 23ai – Fast Ingest Enhancements

Oracle database architects have developed improvements for saving data from IoT devices – Internet of Things. In IoT, we have a lot of small inserts and we are interested in saving them as quickly as possible.

Žiga Vaupot
Pro
Embedding Oracle Analytics Data Visualization in APEX application

In one of my recent projects, the customer had a requirement to integrate visualizations from Oracle Analytics into Oracle APEX application that is running within Oracle Cloud Infrastructure.

 

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!