227 DBMS_VECTOR_ADMIN

The DBMS_VECTOR_ADMIN package provides administrative interfaces for managing database configuration settings, such as modifying system parameters and performing privileged operations.

227.1 Summary of DBMS_VECTOR_ADMIN Subprograms

This table lists the DBMS_VECTOR_ADMIN subprograms and briefly describes them.

Table 227-1 DBMS_VECTOR_ADMIN Package Subprograms

Subprogram Description
GET_PARAMETER

Gets the current value for the specified input parameter.

SET_PARAMETER

Sets the value of the configuration parameters to facilitate the automatic IVF index rebuilds.

227.1.1 GET_PARAMETER

Use the DBMS_VECTOR_ADMIN.GET_PARAMETER procedure to get the current value for the specified input parameter.

Syntax

DBMS_VECTOR_ADMIN.GET_PARAMETER (
    parameter      IN  NUMBER
    value          OUT NUMBER
);

Parameters

Table 227-2 GET_PARAMETER Procedure Parameters

Parameter Description
parameter

The name of the parameter for which you want to get the current value.

value

The current value of the specified parameter. This value is returned by the procedure.

227.1.2 SET_PARAMETER

Use the DBMS_VECTOR_ADMIN.SET_PARAMETER to set the value of the configuration parameters to facilitate the automatic IVF index rebuilds.

Syntax

DBMS_VECTOR_ADMIN.SET_PARAMETER (
    parameter      IN NUMBER
    value          IN NUMBER
);

Parameters

Table 227-3 SET_PARAMETER Procedure Parameters

Parameter Description
parameter

The name of the parameter for which you want to set a value.

value

The value to assign to the specified parameter.