Posted By: nicofari ReadBuffer = set array[size] ? - 03/22/04 01:57 PM
Is the ReadBuffer property equivalent to

set arraysize nn

in SQLPlus?
Posted By: Marco Kalter Re: ReadBuffer = set array[size] ? - 03/23/04 10:10 PM
Yes. It controls the number of records fetched in one network roundtrip.
Posted By: nicofari Re: ReadBuffer = set array[size] ? - 03/26/04 01:52 PM
I asked this because reading the last Kyte's book
I saw that this setting impacts performance even
in lowering consistent gets on the server!
This quite surprised me.
I always thought about this in term of network related issue only (reducing round-trip, band-width consumption and so on)
© Allround Automations forums