Skip to Main Content

Oracle Database Free

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-51955 when attempting to alter vector memory size on 23ai free

John DorlonMay 23 2024

Hello,

I have downloaded the Oracle VM Virtualbox install of version 23ai from here: https://www.oracle.com/database/free/get-started/

I am testing the new VECTOR features.

When I try to size the vector pool according to the steps here: https://docs.oracle.com/en/database/oracle/oracle-database/23/vecse/size-vector-pool.html, using the command: "ALTER SYSTEM SET vector_memory_size=1G SCOPE=BOTH;"

... I receive the following error:

ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-51955: The Oracle Database Vector Memory size cannot be increased more than
0 MB for PDB ID 3.
Help: https://docs.oracle.com/error-help/db/ora-02097/

Is it possible to set vector memory size in the 23ai free database?

Thanks

John Dorlon

This post has been answered by MartinBach-Oracle on May 24 2024
Jump to Answer
Comments
Post Details
Added on May 23 2024
2 comments
379 views