add tag
User 1791
It would be helpful to know if the SPATIAL_VECTOR_ACCELERATION parameter is enabled in db<>fiddle for **Oracle 18c**.

Reason: I'm trying to optimize a spatial query: [Select polygons that intersect points](https://topanswers.xyz). The SPATIAL_VECTOR_ACCELERATION parameter would likely affect the performance of that query.

-----------------



I can't seem to check from a non-dba user [(Oracle Spatial Community link)](https://community.oracle.com/tech/apps-infra/discussion/4500610/check-if-spatial-vector-acceleration-is-enabled-as-a-non-dba):

>     select * from v$parameter;
> 
> ORA-00942: table or view does not exist



>     show parameter SPATIAL_VECTOR_ACCELERATION;
> 
> ORA-00900: invalid SQL statement


*db<>fiddle [here](https://dbfiddle.uk/?rdbms=oracle_18&fiddle=8aec2a1c254d3f14ecec7cad26ceae50)*

This room is for discussion about this question.

Once logged in you can direct comments to any contributor here.

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.