1.19 SPATIAL_VECTOR_ACCELERATION System Parameter

To accelerate the performance of spatial operators, it is recommended that you enable the Vector Performance Accelerator (VPA) feature by setting the SPATIAL_VECTOR_ACCELERATION database system parameter to the value TRUE. (This feature and associated system parameter are authorized for use only by licensed Oracle Spatial and Graph users, and the default value for the parameter is FALSE.)

The benefits of setting the SPATIAL_VECTOR_ACCELERATION parameter to 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 can set this parameter for the whole system or for a single session. 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:

ALTER SESSION SET SPATIAL_VECTOR_ACCELERATION = TRUE;