Titolo"Out of Memory" error when viewing data from table with a lot of columns and rows.DescrizioneError 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. RisoluzioneWORKAROUND 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.
Comments