oracle connector with db looping

I have an oracle database connection where I want to get the data from using a column from another table to filter (let’s say table b). I used a DB Table Selector to pick the table from oracle, which has 460k rows in it.

I tried both Parameterized DB query Reader and DB Looping node with table b at port 1 and the oracle table at port 2 but both of them were stuck running with a message “Copying input object at port 2”.

Is the DB looping trying to copy the full data before the filtering with table b?

Please let me know if there is a way to mitigate it.