Posts

Understanding VECTOR Data Types

  Oracle AI Vector Search Understanding VECTOR Data Types A practical overview of vector data types, SQL usage, and similarity search concepts within Oracle Database. Introduction to Oracle AI Vector Search The release of Oracle Database 23ai marks a paradigm shift in how we handle enterprise data. No longer is Artificial Intelligence a "sidecar" process; with AI Vector Search , the database itself becomes the engine for semantic understanding. At the heart of this revolution is the new, native VECTOR data type. In this article, we will dive deep into the technical specifications, storage formats, and architectural advantages of the VECTOR data type.     1. What is the VECTOR Data Type? A vector is a mathematical representation of unstructured data (text, images, audio, or video) encoded as an array of numbers (dimensions). In Oracle 23ai, the VECTOR data type allows these embeddings to be stored, indexed, and queried using standard SQL. Basic Syntax:...

How to Extend Swap space on LVM Disk Linux

Image
How to Extend Swap space on LVM Disk Linux   Applies to:             Oracle Database 12.2             Oracle Linux 7 Description:             Want to extend Swap space on LVM disk. Assumes that space is available in the volume group on which the current swap partition is located as logical volume. Solution:             To extend the amount of swap space in a LVM environment follow the below steps. To verify the swap space exists and is a logical volume issue the following command:              To view the swap volume using fdisk command: [root@ora12c ~]# fdisk -l We see that current swap space is 7.88GB and we want to extend 2GB to this swap volume. Stop or terminate all program/services which are using sw...