Oracle ADW performs best when using its bulk load capabilities. You can enable it by setting a specific connection property:

.option("oracle.jdbc.defaultBatchValue", "5000")

And try use defaultRowPrefetch 100 which tells the Oracle driver how many rows to fetch (default is 10).

Hope it helps.