In October 2024, Oracle ACEs from all around the world shared tips and tricks, insights, and knowledge in more than 300 blog posts and articles. We have highlighted some of them for you to read and enjoy, focusing on 23ai.
Fernando Simon : 23ai, Zero-Downtime Oracle Grid Infrastructure Patching – GOLD IMAGE
As you know, the 23ai was released for Cloud and Engineered Systems (Exadata and ExaCC) first, I already explored these in previous posts as well. And since the patches already started to be released, now with the patch for 23.6, we can re-test the feature Zero-Downtime Oracle Grid Infrastructure Patching (ZDOGIP). The steps here are not specific to the Exadata version and can be used for any 23ai version.
Mouhamadou Diaw : Secure Application Roles With Oracle 23ai
We know a traditional role in Oracle which is used to group a set of privileges and then grant the role instead of granting privileges themselves. An Oracle traditional role can help to manage and secure the database.
Tomasz Ziss : Oracle 23ai – Real-time SQL Plan Management
In ancient times, a mechanism called stored outlines was used to quickly fix a problematic query plan. These times were around the early 2000s (the articles and blogs I found are from 2005). The problem was that to create such a stored outline, SQL had to be in the cache. It is not always possible to recreate such SQL.
Žiga Vaupot : Using Oracle 23ai Vector Store and Select AI with Retrieval-Augmented Generation (RAG)
In this blog post I am testing an option to use Select AI for Retrieval-Augmented Generation (RAG). Select AI with RAG augments natural language prompt by retrieving data (documents) from vector store (stored in Oracle 23ai). With this additional content, hallucinations can be reduced and much more accurate answers could be retrieved.