Processing 18million records Oracle

I’ve an oracle database with a little over 18m records. I need to fetch these records and run them against a business logic. What will be the best approach - Can a genstage/flow help in this context.
I plan creating a process that will fetch a count of all the records, then start about 20 processes that will fetch records concurrently using limit/row_number then process the records.

4 Likes