Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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