DEV Community

sainathsurender
sainathsurender

Posted on

What is the best way to analyze huge chunks of data in Oracle DB

We have a scenario where we need to analyze 2 lakh rows per day and based on that perform insert and update into other tables respectively. Problem is that Oracle Jobs with Parallel switched on(completely optimized) is not able to process at a faster pace and was thinking if Windows service would do that job. Wanted to know what is the right architecture for processing data from a flat table in the fastest way possible.

Top comments (0)