Description
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
"Out of Memory"
This error does not occur when the number of column or rows displayed are limited
Resolution
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.
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.
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.
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
Limit rows returned to required data using 'WHERE' condition
No comments:
Post a Comment