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

Examples

The following is an example of retrieving and displaying the current background optimization interval setting for vector indexes:

DECLARE
  v_param_val NUMBER;
BEGIN
  DBMS_VECTOR_ADMIN.GET_PARAMETER(parameter => DBMS_VECTOR_ADMIN.VECTOR_INDEX_OPTIMIZATION_BACKGROUND_INTERVAL,
  value => v_param_val);
  DBMS_OUTPUT.PUT_LINE('parameter value = '|| v_param_val);
END;
/

parameter value = 1800 

The following is an example of retrieving and displaying the current status of background optimization for vector indexes:

DECLARE
  v_param_val VARCHAR2;
BEGIN
  DBMS_VECTOR_ADMIN.GET_PARAMETER(parameter => DBMS_VECTOR_ADMIN.VECTOR_INDEX_OPTIMIZATION_BACKGROUND, value => 
  v_param_val);
  DBMS_OUTPUT.PUT_LINE('parameter value = '|| v_param_val);
END;
/

parameter value = 2 

where, the output value 2 indicates that background optimization for vector indexes is enabled globally.