Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Check if SPATIAL_VECTOR_ACCELERATION is enabled (as a non-dba)

User_1871Jul 7 2022

As a non-dba (no access to sys user), is there a way to check if SPATIAL_VECTOR_ACCELERATION is enabled in an 18c database?
(I'm aware that it's enabled by default in 21c+.)
I tried doing this in SQL Developer (using a connection to a specific non-dba user):

--https://geodatamaster.com/tag/spatial_vector_acceleration/

show parameter SPATIAL_VECTOR_ACCELERATION

But it failed:

Show parameters query failed 

Is that the correct/only way to check?
I couldn't find anything in the docs that outlines how to check.
Thanks.

Comments
Post Details
Added on Jul 7 2022
3 comments
611 views