The FET_BUF_SIZE environment variable lets you override the default setting for the size of the fetch buffer for all data except simple large
objects. When set, FET_BUF_SIZE is effective for the entire environment.
n
represents the size of the buffer in bytes.
When set to a valid value, the environment variable overrides the previously set value. The default setting for the fetch buffer is dependent on row
size.
If the buffer size is set to less than the default size or is out of the range of the small integer value, no error is raised. The new buffer size is
ignored.
For example, to set a buffer size to 5,000 bytes, set the FET_BUF_SIZE environment variable by entering the following command:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.