Oracle AI Vector Search is a native capability of Oracle AI Database 26ai that brings AI-powered similarity search to business data without managing separate vector databases. It stores vectors in a native VECTOR data type, generates embeddings with ONNX models or database APIs, and queries them with standard SQL alongside relational, text, JSON, graph, and spatial data. Vector indexes, hybrid indexes, and configurable accuracy targets accelerate semantic search, while retrieval-augmented generation helps LLMs answer with context from private enterprise data. It targets developers and data teams building AI search, recommendation, and RAG applications. Access is available through Oracle AI Database Free and Oracle Cloud Free Tier.
How to use Oracle AI Vector Search
1
Store vectors in the database
Create tables using the native VECTOR data type to hold embeddings with supported dimension counts and formats.
2
Generate embeddings
Import ONNX embedding models, use database APIs with your preferred embedding provider, or import vectors directly.
3
Query with SQL
Use VECTOR_DISTANCE and related SQL functions to rank the top K most similar matches, combined with relational filters and joins.
4
Accelerate with vector indexes
Create in-memory neighbor graph or neighbor partitioned vector indexes, and set target search accuracy as a percentage.
5
Build RAG workflows
Retrieve relevant documents via similarity search and pass them with the user question to an LLM for context-aware answers.
Oracle AI Vector Search Features
Native VECTOR data type with support for BINARY, INT8, FLOAT32, and FLOAT64 formats up to 65,535 dimensions
Flexible vector generation via ONNX models, database APIs, or direct import
Simple standard SQL with VECTOR_DISTANCE for similarity search combined with relational, JSON, text, graph, and spatial data
Vector indexes including in-memory neighbor graph (HNSW) and neighbor partitioned (IVF) indexes
Hybrid vector indexes combining full-text search and semantic vector search
Search accuracy specified as a target percentage
Retrieval-augmented generation support with any LLM, plus LangChain and LlamaIndex integration
Sparse vector support and custom vector distance functions
Vectors on Apache Iceberg tables with vector indexes
Enterprise security, high availability, and Exadata optimizations
Oracle AI Vector Search Use Cases
Semantic search of documents
Semantic search of images
Recommendation systems
Pattern recognition
Anomaly and fraud detection
Chatbots for internal and external users
Document searches and summaries
Answers to questions requiring domain-specific knowledge via RAG
Oracle AI Vector Search FAQs
A vector is a mathematical representation of text, images, audio, or video that encodes semantic meaning as a list of numerical dimensions, used for AI operations such as similarity search.
Embedding models create vectors from input data. You can generate them outside the database, use ONNX models inside the database via the VECTOR_EMBEDDING() SQL function, or import vectors directly.
Oracle AI Vector Search supports BINARY, INT8, FLOAT32, and FLOAT64 formats, with vectors up to 65,535 dimensions. Sparse vectors are also supported.
SQL extensions such as VECTOR_DISTANCE sort candidate vectors by distance from a search vector and return the top K closest matches, and can be combined with filters, joins, and aggregations.
Vector indexes find the top K most similar matches by semantic similarity rather than exact value matching. They perform approximate search that trades some accuracy for up to 100X greater performance.
It can be used for RAG with any LLM, including open source models such as Llama3 and Mistral and proprietary models from providers like OpenAI and Cohere. It is integrated with LangChain and LlamaIndex.
In addition to SQL and PL/SQL, AI Vector Search includes native driver support for vectors in Java, Python, JavaScript, and C#.
You can get started through Oracle AI Database Free or the Oracle Cloud Free Tier, and follow LiveLabs workshops such as Getting Started with AI Vector Search.
Oracle AI Vector Search is a built-in feature of Oracle AI Database and is included in Oracle AI Database 26ai Free at no charge, with limits of up to 2 CPU threads, 2 GB database RAM, and 12 GB of user data. This is an enduring free edition, not a time-limited trial. Paid commercial editions of Oracle AI Database are not priced on the reviewed pages; contact Oracle sales for commercial licensing.
Oracle AI Database 26ai Free (includes AI Vector Search)
$0USD / free (no time limit)
Free edition of Oracle AI Database 26ai that includes AI Vector Search. Limited to up to 2 CPU threads, 2 GB database RAM, and 12 GB of user data.
AI Vector Search with vector data types, indexes, and SQL operators