SPATIAL_VECTOR_ACCELERATION System Parameter

1.25 SPATIAL_VECTOR_ACCELERATION System Parameter

To optimize the performance of spatial operators, the SPATIAL_VECTOR_ACCELERATION database system parameter value must be TRUE.

The Vector Performance Accelerator (VPA) feature, which accelerates the performance of spatial operators, is controlled by the value of the SPATIAL_VECTOR_ACCELERATION database system parameter. Effective with Release 21c, the default value for this parameter is TRUE.

The benefits of having the SPATIAL_VECTOR_ACCELERATION parameter be TRUE include:

Improved spatial algorithms for spatial operators and functions
Metadata caching for all spatial operators and functions, which improves their overall performance
Metadata caching for all DML operations, which makes insert, update, and delete operations on spatial tables run faster

You should not set this parameter to FALSE unless you have a very good reason to do so. If you need to explicitly set the value to TRUE or FALSE (such as to change it to TRUE after setting it to FALSE), you can set the value for the whole system or for a single session. For example, to set the value for the whole system, do either of the following:

Enter the following statement from a suitably privileged account:
```
ALTER SYSTEM SET SPATIAL_VECTOR_ACCELERATION = TRUE;
```
Add the following to the database initialization file (xxxinit.ora):
```
SPATIAL_VECTOR_ACCELERATION = TRUE;
```

To set the value for the current session, enter the following statement from a suitably privileged account. For example:

ALTER SESSION SET SPATIAL_VECTOR_ACCELERATION = TRUE;