Hi all,
Need help finding a strategy that allow process 12 millions of records in less than 1 hour. Each record can be modified by business rules. In this process are performed insert, update and select in other 3 tables.
This process is part of the migration of Cobol to Java/Oracle. In cobol this process takes approximately one hour.
What would be the appropriate strategy using PL / SQL (Bulk collect and others ???)
Currently we have migrated in PL / SQL but the process takes too long .
Sorry my english and thank you very much.