Product(s): | Exor Core | ||
Version(s): | 4.8.0.0 | ||
Environment: | N/A | ||
Area: | GIS Themes | ||
Subarea: | Create GIS Theme |
NOTE: This issue was encountered at a client site. No error was encountered but some theme locations would not display, even after dropping and recreating the theme. Setting the following Oracle parameter for the system resolved the issue.
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;
Original Author: | Jon Libby |