I have installed Oracle 23c Free in a Docker image. One of the new features is that you can insert multiple values in a single statement, just like all the other DBMSs.

I tested this by adding about 13,692 rows. In other DBMS, such as PostgreSQL, MySQL and MSSQL (with workaround), it really only takes a few seconds. With Oracle, it took over five minutes.

In previous versions, I would take these rows, break it up into about ten groups, and insert from multiple massive UNION ALL statements. It would take about half a minute.

I know it’s the free version, but should it really take a hundred times as long? Is there something I should do to make things work more smoothly?