Toad World® Forums

out of memory

What causes the out of memory error? I am getting that right now

What were you doing at the time that the error happened?

running a query

Angela L. Haynie

Mediation Support Specialist

IBM Resiliency Services - Global Technology Services*
3039 Cornwallis Road

Bldg. 060, Office R105C

Research Triangle Park, NC 27709

Voice: (919) 254-1159/Tie Line 444-1159;Fax Number:*(919)-254-2409

Did you run it as a script? With F5? If so, try running with F9 instead. That will fetch the rows much more efficiently, and it won’t fetch all of them unless you scroll down to see all of them, and in that case, it will probably still take less memory than running with F5.

Hi,

Had not got as far as getting the data, I ran the select statements to grab data foe Oct Billing and within less than a minute it stopped after I hit run and said "Out of memory’ I had not reached as far as to create the xls sheet to deliver.

So one said I may have to uninstall TOAD clean it, then reinstall. Do not know what Clean it means. I had a co-worker run the select statements on his computer so we could try to generate the report that is due today and it ran fine on his machine with no issues.

Thanks,

Angela L. Haynie

Mediation Support Specialist

IBM Resiliency Services - Global Technology Services*
3039 Cornwallis Road

Bldg. 060, Office R105C

Research Triangle Park, NC 27709

Voice: (919) 254-1159/Tie Line 444-1159;Fax Number:*(919)-254-2409

ok. but when you run it, are you running by clicking the button that I’ve circled in red or green? Green will require less memory.

RunSQL.jpeg

Hi,

I am clicking the green button

Angela L. Haynie

Mediation Support Specialist

IBM Resiliency Services - Global Technology Services*
3039 Cornwallis Road

Bldg. 060, Office R105C

Research Triangle Park, NC 27709

Voice: (919) 254-1159/Tie Line 444-1159;Fax Number:*(919)-254-2409

Well what does task manager show for total memory usage and Toad’s memory usage?

Do you have lots of windows and/or editor tabs open in Toad? Is the dataset that you are returning very large? Does it happen with every query or just this one?

Just happens with this one , checked memeory , had closed other tabs , still would not run that query but ran fine on my coworker maching, you think I need to uninstall and reinstall if so what did he mean by “clean it” before reinstalling TOAD?

Angela L. Haynie

Mediation Support Specialist

IBM Resiliency Services - Global Technology Services*
3039 Cornwallis Road

Bldg. 060, Office R105C

Research Triangle Park, NC 27709

Voice: (919) 254-1159/Tie Line 444-1159;Fax Number:*(919)-254-2409

I think by “clean it”, they meant to make sure all files and folders created by Toad are gone. you could just try going to the main menu, then Utilities, then “Copy User Settings”, check “Reset to a clean set of user files” and click OK. That will restore Toad to the default settings, and it will look like it was freshly installed. I don’t think this will solve the problem though.

Generally this error does not just come up for no reason. Either there is not enough free physical memory on the machine to fetch the rows, or Toad is 32 bit and approaching its memory limit (which is around 1.5Gb).

It could just be that this is a large dataset, and your coworker has more memory than you. It’s hard to tell you exactly what’s going on without more information.

If your computer has plenty of free memory and it’s a 64 bit machine, then make sure you have 64 bit Toad. It is much less likely to show you this error. You can check if your Toad is 32 or 64 under Help -> Support Bundle.

Hi,

This is what I got when I went to Help>support bundle so this means mine is 32bit now going to see what my coworkers is that was able to run it fine.

APPLICATION INFORMATION - FULL VERSION (32-bit)


Support Bundle for Toad for Oracle 12.1.0.22

This copy of Toad for Oracle registered to INTERNATIONAL BUSINESS MACHINES CORP

Bundle: Add-Ons: Toad for Oracle Xpert (32-bit)DB Admin Module

Toad for Oracle Executable Location : C:\Quest Software\Toad for Oracle 12.1\Toad.exe

User Profile Directory : C:\Users\IBM_ADMIN\AppData\Roaming\Quest Software\Toad for Oracle\12.1\

Knowledge Xpert DLL Location : C:\Quest Software\Toad for Oracle 12.1\Revbase.dll

Knowledge Xpert Version : 5.6.0.6

QSEServer DLL Location : C:\Quest Software\Toad for Oracle 12.1\qse.dll

QSEServer Version : 12.1.0.22

QP5 DLL Location : C:\Quest Software\Toad for Oracle 12.1\QP5.dll

QP5 Version : 5.256.13226.35510

QP5CA DLL Location : C:\Quest Software\Toad for Oracle 12.1\QP5CA.dll

QP5CA Version : 5.256.13226.35660

TOAD Policy Location : C:\Quest Software\Toad for Oracle 12.1\Toad.pdl

Angela L. Haynie

Mediation Support Specialist

IBM Resiliency Services - Global Technology Services*
3039 Cornwallis Road

Bldg. 060, Office R105C

Research Triangle Park, NC 27709

Voice: (919) 254-1159/Tie Line 444-1159;Fax Number:*(919)-254-2409

Hi,

My coworker that was able to run the query fine has 32 bits TOAD as well.One difference being when he runs the select statement select`` * ``from`` mediation``.``idc_br_events it pulls 500 records at a time . If I run the same select statement it keeps going and going and he says that is what is making me run out of memory but we do not know where to change it where mine will pull only 500 records at a time as well.

Thanks,

Angela L. Haynie

Mediation Support Specialist

IBM Resiliency Services - Global Technology Services*
3039 Cornwallis Road

Bldg. 060, Office R105C

Research Triangle Park, NC 27709

Voice: (919) 254-1159/Tie Line 444-1159;Fax Number:*(919)-254-2409

Earlier John asked if you were clicking the button he “circled” in green and you replied that you’re “clicking the green button.” :slight_smile: Both are green buttons! Look at his screenshot again. Click the button circled in green (the keyboard shortcut is F9) if you’re not already. That method of execution limits results. If that is the button you’re clicking then right-click in the Editor and make sure that “Auto Trace” is unchecked. If that is checked all results are fetched.

can you resend screen shot do not have it

Angela L. Haynie

Mediation Support Specialist

IBM Resiliency Services - Global Technology Services*
3039 Cornwallis Road

Bldg. 060, Office R105C

Research Triangle Park, NC 27709

Voice: (919) 254-1159/Tie Line 444-1159;Fax Number:*(919)-254-2409

www.toadworld.com/…/RunSQL.jpg