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!

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
2,400 views