Hi All,
we are using Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Now in one of the Processes, we have created a staging table. We are dumping 1.2 Million records and deleting those.
The Delete is performed at multiple instance within the process. I cannot run the Truncate the table within the process as other sessions are also trying to insert their data and then delete their inserted data.
I am planning to Truncate the table once all the Process completes the operations. But I am not sure what can I do to improve the performance of the intermediate multiple Delete operations within the process.
These are staging tables so they have to be cleared off anyway. I am not sure if I can disable the generation of Logs and if that would be helpful?
Any suggestions will be appreciated.
Regards
VInod