TOAD - "Out of Memory" error when viewing data from table with a lot of columns and rows.

Titolo
"Out of Memory" error when viewing data from table with a lot of columns and rows.
Descrizione
Error received when viewing data in Schema Browser | Tables | Data tab or from SQL Editor | Data Grid tab from a table that contains a large amount of columns and rows:

"Out of Memory"

This error does not occur when the number of column or rows displayed are limited.

Risoluzione
WORKAROUND 1:
1. Select View | (Toad) Options | Oracle | General.
2. Decrease the OCI array buffer size to a smaller amount or to Oracle's default value of 25.

WORKAROUND 2:
View | Toad Options | Data Grid | Data - increase 'stop data fetches when available memory reaches __ MB' to 128mb.
WORKAROUND 3:
Use F9 (Execute as Statement) instead of F5 (Execute as Script) so that Toad will only fetch about 500 records rather than all the records.
WORKAROUND 4:
Limit rows returned to required data using 'WHERE' condition and ORDER BY clauses.
STATUS:
Waiting for fix in a future release of Toad for Oracle.