Hi @sidd1582
It could be any number of things, from input to your workflow taking a long time to the oracle database being slow to your internet connection being overloaded. To try and track down where the problem could be, start isolating the individual pieces.
1. Enable Performance Profiling on the Workflow - Configuration-> Runtime tab. You may find that one of the tools is taking up all the time.
2. Disable the Oracle output and add a new output that writes to a local .yxdb file. If this is very quick, then the problem is with the connection to Oracle. Write the output to a csv file and use PL/SQL or Toad to read this file and write to Oracle. If Toad still slow the issue is with your connection to Oracle or possible the Oracle itself.
3. Disable your entire workflow aside from the inputs and check the speed. It could be the data sources that are slow
Dan
