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 12-36 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.

Example

The following is an example of setting the background optimization interval for vector indexes to 1800 seconds:

DECLARE
BEGIN
   DBMS_VECTOR_ADMIN.SET_PARAMETER(parameter => DBMS_VECTOR_ADMIN.VECTOR_INDEX_OPTIMIZATION_BACKGROUND_INTERVAL,
   value => 1800);
END;
/