One of my procedures failed because it ran out of temp tablespace. 700 GB was not enough for the procedure. I looked on it, and found it was caused by an inefficient join type, chosen by the optimizer. It works well with nested loops, and is fast enough. So, I disabled the hash and merge joins inside the procedure.
I have a question. If I disabled this hash join, would that change affect other procedures?
Would it affect procedures which calls modified procedure?
And would it affect procedures which are called by the modified procedure?