Depends on what you use to write it, if you use java, I think the only way to do it is to do it via jdbc via batch commit or write the in-memory data to a file and then use oracle's sqlldr to process it.

There is also the possibility of calling oracle's process through java, passing the data in memory through a collection into oracle's process, inserting into the database with

forall in the process, which reduces the pressure on the application server, and the process is executed on the oracle server, how to eliminate the need for frequent network transfers.