The flow starts with processors GenerateTableFetch and after that ExecuteSQL. They use service which connects to the Oracle database.
If GenerateTableFetch gets new data all the time no issue discovered. But if for a long period in DB no new records and we insert one processor stuck for 15 minutes. Only after 15 minutes processor gets new data.
Any ideas where to search timeouts or stuck connections or use some connection parameters?