Skip to Main Content

Oracle Database Discussions

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!

Performance Tuning Loading Vector Data

dba_chadNov 18 2025

Greetings,

We currently run 23.9 but will be soon applying the 23.26 RU. When dealing with large amounts of data (250+ million rows), in which each row has a related vector column, what are we finding to be the most efficient way to manage this data?

Load the vector data in line, in a batch methodology, as the data is getting originally inserted?

Load the data minus the vector data, and then use dbms_parallel_execute as a post task to load the vector data?

Other options?

Comments
Post Details
Added on Nov 18 2025
0 comments
70 views