In Database Toolbox 3.5.1 (R2009a) the default value of the JDBC property 'defaultRowPrefetch' was changed from 10 to 10000. This change should increase the performance of the toolbox, however it will also increase the memory requirements of the toolbox.
To prevent the out of memory error from occuring, you can change this property back to its default value; below instructions for this are given for different versions of the toolbox:
To change the property in Database Toolbox 3.5.1 (R2009a):
After creating the connection:
Run the following code:
h = conn.Handle;
h.setDefaultRowPrefetch(10);
To change the property in Database Toolbox 3.6 (R2009b):
Run the following code:
setdbprefs('DefaultRowPrefetch','10')
Best Answer