Use Vectors with Autonomous AI Database

Autonomous AI Vector Database is optimized for vector workloads and designed for AI-powered applications. You can build semantic search, retrieval-augmented generation (RAG) pipelines, store and retrieve vector embeddings, and create agentic applications.

When to use Autonomous AI Vector Database

Use Autonomous AI Vector Database when you want to store vector embeddings and build AI-powered applications that retrieve content by meaning rather than by keyword alone.

For example, use it to:

  • Build semantic search over enterprise content.
  • Retrieve relevant content to ground large language model (LLM) responses in a RAG application.
  • Store, index, and query embeddings through vector-specific APIs.
  • Develop AI agents that retrieve semantically relevant data.
  • Manage vector storage, indexing, embedding models, and vector similarity search without deploying and operating a separate vector database.

In practice, a knowledge-search application can find related enterprise documents by meaning, a RAG application can ground LLM responses in proprietary content, and an AI agent can retrieve relevant context as it performs tasks. You can also build recommendation applications that match users, products, or content by similarity.

For more examples and use cases, see the Vector Database documentation.

How Vector Database works with Autonomous AI Database

Autonomous AI Vector Database is an Autonomous AI Database workload optimized for vector-based AI applications. It provides managed vector storage, indexing, embedding-model management, and vector similarity search for data such as documents, images, video, and audio.

Provision an Autonomous AI Vector Database by selecting Vector Database as the Autonomous AI Database workload type. The Vector Database workload requires Oracle AI Database 26ai or later.

Each Autonomous AI Database instance with vector workloads includes a fully managed vector database. From the Autonomous AI Vector Databases page, you can view instance information, monitor the database, manage tags, open Vector Database Console, and manage database users.

Before you Begin

Before using Autonomous AI Vector Database, verify the following:

  • Provision an Autonomous AI Vector Database instance with the Vector Database workload type.
  • Use Oracle AI Database 26ai or later.
  • Create a Vector Database user during initial provisioning, in addition to the ADMIN user. The user name must begin with an alphabetic character and can contain alphanumeric characters and underscores. The Create Vector user performs the following automatically:
    • Grant each Vector Database user the following roles:
      • DB_DEVELOPER_ROLE
      • OML_DEVELOPER
    • Assign an appropriate quota on the DATA tablespace for each Vector Database user.
    • Enable REST access for users who access vector APIs or Vector Database Console.
    • Enable a resource principal for a user who needs access to Oracle Cloud Infrastructure resources, such as Object Storage. See Use Resource Principal to Access Oracle Cloud Infrastructure Resources for more information.

Access Autonomous AI Vector Database

To access an Autonomous AI Vector Database instance:

  1. Open the Oracle Cloud Infrastructure Console.
  2. From the navigation menu, select Oracle Database, and then select Autonomous AI Database.
  3. On the Autonomous AI Databases page, locate the database that you created when provisioning the Autonomous AI Vector Database instance.
  4. Select the database display name.
  5. On the Autonomous AI Database details page, under Instances, select the Vector instance name.

The Autonomous AI Vector Databases page opens.

From the Autonomous AI Vector Databases page, you can:

  • View Autonomous AI Database information, including instance type, database version, ECPU count, storage, and backup details.
  • View Monitoring metrics for health, capacity, and performance.
  • Manage instance Tags.
  • Open Vector Database Console to manage models and access vector-specific operations.
  • Return to the related Autonomous AI Database details page.

For detailed steps, see Access an Autonomous AI Vector Database Instance.

Work with Autonomous AI Vector Database

  • Create Vector Database Users: Create database users, assign the required quota and roles, enable API and web access, and configure access to Oracle Cloud Infrastructure resources.
    • Create additional Vector Database users after the instance is available.
    • Grant DB_DEVELOPER_ROLE and OML_DEVELOPER to Vector Database users.
    • Enable REST, GraphQL, MongoDB API, and web access as needed.
    • Enable resource principal access for users who access Oracle Cloud Infrastructure resources.
  • Use the Vector Database Console: From the Autonomous AI Vector Databases page, click Open Vector Database Console. When the Workload type field is Vector Database, you can also open the console by clicking Open Vector Database Console in that field. With the Vector Database console, you can:
    • Manage Models
    • Manage Vector Tables
    • Use the Query Playground
    • Access APIs for vector-specific operations

Use Vectors with the Autonomous AI Transaction Processing (ATP) Workload

Use the Autonomous AI Transaction Processing (ATP) workload for applications that are primarily transactional or require more than 20 GB of non-vector data. To transition an Autonomous AI Vector Database instance to ATP, change the workload type to Autonomous AI Transaction Processing.

To identify user-created non-vector objects that count toward the 20 GB limit, see DBA_NONVECTOR_OBJECTS View. For the steps to change the workload type, see Upgrade an Autonomous AI Vector Database Instance for Production.

Tip:

Use the DBMS_VECDB_UTIL.GET_USER_NONVECDB_SIZE_GB function to obtain the total size of user-created non-vector database objects in gigabytes:

SELECT DBMS_VECDB_UTIL.get_user_nonvecdb_size_gb;

The function returns the total size as a NUMBER value in gigabytes. You can use the returned value to monitor non-vector data usage and determine when to change the workload type to Autonomous AI Transaction Processing.

Autonomous AI Vector Database limitations and restrictions

  • Autonomous AI Vector Database requires Oracle AI Database 26ai or later.
  • The Vector Database workload supports up to 20 GB of non-vector data.
  • Private endpoint access is not available for Free or Developer Vector Database instances.
  • Only one Vector Database user can be created during initial provisioning. Create additional users after the instance is available.
  • Supply the provisioning-time Vector Database user only when creating a new instance. Do not provide it for clone, recovery, undelete, or other create-from-existing-instance operations.