Re: how to Change parameter at statement level

Does this all have a purpose?

From your test cases, all I see is a consistent 46k PHYSICAL reads. Don't quite understand that.

From what I seem to know about MBRC, upping it to a value, that would make Block_size * MBRC > 64kByte is not valid, and will cause Oracle to use a lower value, such that the outcome is 64kByte or less.
The 64kByte is OS dependent, I think it can be 128kByte on some OSes.

All in all, setting it to 128 seems to big for what your OS can handle. Of course, I could be wrong, as you insist this is not OS related, and won't reveal the OS.

Hint:
- optimizer_mode=ALL_ROWS

• make the remote table a local materialized view -- Regards, Frank van Bortel