Tércio Costa

Oracle 26ai: Vector Indexes Vector indexes are data structures designed to accelerate similarity searches. There are two different vector index types and one new memory structure. Let's first talk about the new memory structure: the Vector Pool. The vector pool is a memory area allocated in the SGA. This pool is mandatory for the HNSW index type because this index exists only in memory, not on disk.

Let's see the two different types of Vector index available in Oracle Database 26ai #oracle #vector #ai

Oracle 26ai Vector Search: Vector Distance Functions and Operators There is one main function to calculate the distance between vectors: VECTOR_DISTANCE. It takes two mandatory parameters, the two vectors to compare, and one optional paramenter, the metric. Let's start with some examples: SQL> CREATE TABLE vectotab(id NUMBER, vec_emb VECTOR); INSERT INTO vectotab VALUES(1,''); INSERT INTO vectotab VALUES(2,''); INSERT INTO vectotab VALUES(3,''); INSERT INTO vectotab VALUES(4,''); INSERT INTO vectotab VALUES(5,''); COMMIT; Table created.

There is one main function to calculate the distance between vectors: VECTOR_DISTANCE. It takes two mandatory parameters, the two vectors to compare, and one optional paramenter, the metric. Let's start with some examples #oracle #database #oracle26ai #oracleace

Oracle Vector Search: Distance Metrics There are several ways you can calculate distances to determine how similar, or not, two vectors are. I'll introduce you each metric available in Oracle 26ai. Euclidean and Euclidean Squared Distances Computed using straight-line distance between two vectors. This is calculated using the Pythagorean theorem (SQRT(SUM((xi-yi)2))). Euclidean Squared avoid the square-root calculation, so, it's faster to compute. Cosine Similarity Measures the cosine of the angle between two vectors.

There are several ways you can calculate distances to determine how similar, or not, two vectors are. I'll introduce you each metric available in Oracle 26ai. #oracle #ai #oracleai #oracle26ai #vectorsearch #oracleace

Oracle 26ai Vector Search: Embedding large unstructed data In my last post, i demostrated how to create embeddings from small texts. But for large unstructured data, we need to do more steps before generating the vector embedding. First we need to prepare the large unstructured text, like a PDF, transforming the document in plain text. Then, we can split the large plain text into small piece, or chunks, of data, to be processed by the vetor embedding model.

Oracle 26ai Vector Search: Embedding large unstructed data

In my last post, i demostrated how to create embeddings from small texts. But for large unstructured data, we need to do more steps before generating the vector embedding. First we need to prepare the large unstructured text, like a PDF,…

Oracle 26ai: Generate and store Vector Embeddings Now that we have an embedding model into the database, let's generate and store vector embeddings into the database. First, let's create a table to store our vectors embeddings and insert a few rows: SQL> CREATE TABLE galaxies ( id NUMBER, name VARCHAR2(50), doc VARCHAR2(500), embedding VECTOR ); Table created. SQL> INSERT INTO GALAXIES(ID,NAME,DOC) VALUES(1,'M31','Messier 31 is a barred spiral galaxy in the Andromeda constellation which has a lot of barred spiral galaxies'); INSERT INTO GALAXIES(ID,NAME,DOC) VALUES(2,'M33','Messier 33 is a spiral galaxy in the Triangulum constellation'); INSERT INTO GALAXIES(ID,NAME,DOC) VALUES(3,'M58','Messier 58 is an intermediate barred spiral galaxy in the Virgo constellation'); INSERT INTO GALAXIES(ID,NAME,DOC) VALUES(4,'M63','Messier 63 is a spiral galaxy in the Canes Venatici constellation'); INSERT INTO GALAXIES(ID,NAME,DOC) VALUES(5,'M77','Messier 77 is a barred spiral galaxy in the Cetus constellation'); INSERT INTO GALAXIES(ID,NAME,DOC) VALUES(6,'M91','Messier 91 is a barred spiral galaxy in the Coma Berenices constellation'); INSERT INTO GALAXIES(ID,NAME,DOC) VALUES(7,'M49','Messier 49 is a giant elliptical galaxy in the Virgo constellation'); INSERT INTO GALAXIES(ID,NAME,DOC) VALUES(8,'M60','Messier 60 is an elliptical galaxy in the Virgo constellation'); 1 row created.

Oracle 26ai: Generate and store Vector Embeddings

Now that we have an embedding model into the database, let's generate and store vector embeddings into the database. First, let's create a table to store our vectors embeddings and insert a few rows: SQL> CREATE TABLE galaxies ( id NUMBER, name…

Oracle 26ai Vector Saerch: Import Pretrained Models in ONNX Format In this post i will demonstrate how can you import a pretrained model in ONNX format into the database. I'm, gonna use the the model that Oracle provides for import into the database, the all_MiniLM_L12_v2 model. You can use any model that you want, but first you need to convert the model to ONNX format augmented with pre-processing and post-processing steps.

Oracle 26ai Vector Saerch: Import Pretrained Models in ONNX Format

In this post i will demonstrate how can you import a pretrained model in ONNX format into the database. I'm, gonna use the the model that Oracle provides for import into the database, the all_MiniLM_L12_v2 model. You can use any…

Oracle AI Vector Search Fundamentals         Let's talk now about the fundamentals about Vector Search. First, let's see how create tables with vector data types columns with different dimensions and/or formats. If we create a table with a column of vector data type without specify the number of dimensions and format, like this: CREATE TABLE my_vectors (id NUMBER, embedding VECTOR); We can insert vector embeddings with any number of dimensions up to 65535(non binary), for binary the maximum number of dimensions is 65528, and in any data format. 

Oracle AI Vector Search Fundamentals        

Let's talk now about the fundamentals about Vector Search. First, let's see how create tables with vector data types columns with different dimensions and/or formats. If we create a table with a column of vector data type without specify the number of…

Overview of Oracle AI Vector Search This is the first post in a series about Vector Search, introduced in Oracle 23ai and updated with every new release. Let's start talking about what a Vector Data Type is. The Vector Data Type is the way you can store vector embeddings in the database. To accomplish this, you need to use an embedding model to transform unstructured data into the vector embedding.

Overview of Oracle AI Vector Search

This is the first post in a series about Vector Search, introduced in Oracle 23ai and updated with every new release. Let's start talking about what a Vector Data Type is. The Vector Data Type is the way you can store vector embeddings in the database. To…

Oracle Database Cloud Backup Module With Oracle Database Cloud Backup Module we can backup our on-premises Oracle Database to the OCI Object Storage! First, let's create an user in OCI with only the privileges to use the object storage: Allow group <group_name> to manage objects in compartment <compartment_name> where target.bucket.name = '<bucket_name>' Allow group <group_name> to read buckets in compartment <compartment_name> Create a SSH key pair for the user using the OCI Console.

Oracle Database Cloud Backup Module

With Oracle Database Cloud Backup Module we can backup our on-premises Oracle Database to the OCI Object Storage! First, let's create an user in OCI with only the privileges to use the object storage: Allow group  to manage objects in compartment…

Creating an Oracle DB Link from on-premises to an Autonomous Database In this blog post i will demonstrate how can you create an Oracle Database link between your database on premises and an Autonomous in the OCI. First, you need to download the instance wallet to be able to connect to your ATP database. Go to your OCI Console, select your Autonomous database and in Database connection click in download the wallet and copy the connection string.

Creating an Oracle DB Link from on-premises to an Autonomous Database

In this blog post i will demonstrate how can you create an Oracle Database link between your database on premises and an Autonomous in the OCI. First, you need to download the instance wallet to be able to connect to your ATP…

🚀 We’re excited to announce a brand-new entry path to the Oracle ACE Program: ACE Apprentice—launching at Oracle AI World! ♠️

The ACE Apprentice level is designed to kickstart your journey as an Oracle advocate and unlock your potential within the global community. 🔒 🔑 💻

👉 ace.oracle.com/apprentice

Oracle 26ai Released – Free Edition available! Today, at Oracle AI World 2025, Oracle has released the new 26ai version. The new Oracle documentation is already available, so you can see all the new features: And one major news about is that you don't need to upgrade your database to get the new 26ai! If you are using the 23ai you just need to install the October 2025 patch and you are done!

Oracle 26ai Released – Free Edition available!

Today, at Oracle AI World 2025, Oracle has released the new 26ai version. The new Oracle documentation is already available, so you can see all the new features: And one major news about is that you don't need to upgrade your database to get the new…

Upgrade Oracle Linux with Leapp As Oracle Linux 7’s premier support has reached its end on December 24, you have two choices. Or you pay more for the extended support, which only provides security issues and select high-imp…

Upgrade Oracle Linux with Leapp
oraclepress.wordpress.com/2025/04/28/u...
@oracleace.bsky.social #oracle #linux #oraclelinux #upgrade #leapp

Sysdate and Systimestamp Enhancements in Oracle Database 23ai Quem nunca ao usar um Oracle Autonomous Database, ou até mesmo um outro flavour, ao executar um SYSDATE veio uma hora completamente diferente do seu horário local? Pior, sabemos que em um ADB isso …

Sysdate and Systimestamp Enhancements in Oracle Database 23ai
oraclepress.wordpress.com?p=6576&previ...
@oracleace.bsky.social #oracle #database #orcl #sysdate

Lock-free Reservations – Oracle Database 23ai New Feature Quando estamos alterando algum registro em uma tabela no banco de dados o Oracle irá colocar um lock nesse registro para que ninguém mais possa alterar ele até você executar um commit ou rollback. …

Lock-free Reservations - Oracle Database 23ai New Feature

oraclepress.wordpress.com/2025/04/02/l...

@oracleace.bsky.social #oracle #database #23ai #oracle23ai

Automatic Transaction Quarantine – Oracle Database 23ai New Feature Uma new feature do Oracle Database 23ai é a Automatic Transaction Quarantine qeu ajuda a aumentar a disponibilidade do nosso banco fazendo com que uma falha em uma transaction recovery não faça um …

Automatic Transaction Quarantine – Oracle Database 23ai New Feature
oraclepress.wordpress.com/2025/03/25/a...
@oracleace.bsky.social #oracle #23ai #database #orcl23ai #oraceace #acesinaction

Priority Transactions – Oracle Database 23ai new feature Quem nunca precisou executar um KILL SESSION de uma sessão que esta idle mas bloqueando outra sessão? Isso realmente é algo muito comum. Mas, a partir da versão 23ai, temos uma new feature, Priority Transactions, que pode nos ajudar nesse tipo de situação. Priority Transactions ajuda a quando e quais transactions serão feitas rollback automaticamente, isso mantendo a sessão ativa.

Priority Transactions – Oracle Database 23ai new feature

Quem nunca precisou executar um KILL SESSION de uma sessão que esta idle mas bloqueando outra sessão? Isso realmente é algo muito comum. Mas, a partir da versão 23ai, temos uma new feature, Priority Transactions, que pode nos ajudar nesse…

Implement Oracle True Cache Service with Oracle Database 23ai No post passado mostrei como configurar o True Cache no Oracle Database 23ai Free Edition. Agora irei demonstra na Enterprise Edition. Sim, os procedimentos são diferentes. Primeiro, antes de tudo, você deve ter o Oracle 23ai enterprise edition instalado em duas máquinas diferentes, um já com o banco criado em modo archivelog. Fora isso, você precisa copiar o password file de uma máquina para outra, esse password file será utilizado no passo seguinte.

Implement Oracle True Cache Service with Oracle Database 23ai

No post passado mostrei como configurar o True Cache no Oracle Database 23ai Free Edition. Agora irei demonstra na Enterprise Edition. Sim, os procedimentos são diferentes. Primeiro, antes de tudo, você deve ter o Oracle 23ai enterprise…

Configuring True Cache on Oracle Database Free Aqui que já entendemos o que é o Oracle True Cache nesse post, vejamos como configurar ele no Oracle Database 23ai Free, que é um pouco diferente da versão enterprise que irei demonstrar em outro post. Primeiro, antes de tudo, precisamos que o Oracle Database 23ai Free esteja instalado em duas máquinas diferentes. Na primeira você já terá um banco executando.

Configuring True Cache on Oracle Database Free

Aqui que já entendemos o que é o Oracle True Cache nesse post, vejamos como configurar ele no Oracle Database 23ai Free, que é um pouco diferente da versão enterprise que irei demonstrar em outro post. Primeiro, antes de tudo, precisamos que o Oracle…

Using Tmux on Oracle Linux – Terminal Multiplexer Por padrão, ao terminar uma conexão no terminal linux, todas as outras conexões remotas iniciadas por essa mesma conexão também são finalizadas. Eu já vi DBA instando o GUI do linux para fazer uma conexão via VNC para instalar o Oracle com medo da conexão cair no meio da instalação o.O. Eu mesmo já fui de utilizar muito o nohup junto com o "&" no final para deixar executando o comando de um duplicate por exemplo, sem ter medo da conexão finalizar.

Using Tmux on Oracle Linux – Terminal Multiplexer

Por padrão, ao terminar uma conexão no terminal linux, todas as outras conexões remotas iniciadas por essa mesma conexão também são finalizadas. Eu já vi DBA instando o GUI do linux para fazer uma conexão via VNC para instalar o Oracle com medo da…

Install Oracle 23ai Free – OCI Nesse post irei demonstrar de maneira bem simples como instalar o Oracle 23ai Free na OCI, utilizando uma instance ARM com Oracle Linux 8. Isso será útil para testar as new features dos postes que estou começando a fazer. Para fazer o download, é somente ir no seguinte link Agora, vamos instalar. Primeiro, vamos instalar o preinstall, que pode ser feito o download no mesmo link.

Install Oracle 23ai Free – OCI

Nesse post irei demonstrar de maneira bem simples como instalar o Oracle 23ai Free na OCI, utilizando uma instance ARM com Oracle Linux 8. Isso será útil para testar as new features dos postes que estou começando a fazer. Para fazer o download, é somente ir no…

Oracle True Cache O Oracle True Cache é uma nova feature do Oracle 23ai, no qual estou iniciando uma série de posts sobre essas new features. O Oracle True cache é um cache para o Oracle Database de chave-valor, seja json ou objeto, in-memory, consistente, automaticamente gerenciável. Veremos diversas vantagens do uso dele em comparação com outras soluções como o redis, que é tão famoso.

Oracle True Cache

O Oracle True Cache é uma nova feature do Oracle 23ai, no qual estou iniciando uma série de posts sobre essas new features. O Oracle True cache é um cache para o Oracle Database de chave-valor, seja json ou objeto, in-memory, consistente, automaticamente gerenciável. Veremos…