Toad World® Forums

Toad for Oracle 10.6.1.3 Out of memory errors


#1

Anyone getting (more) “out of memory” errors with TFO 10.6.1.3?
I’m at point where I can hardly run some queries that ran fine in older
Toads. I’m running Win7 64bit with 8G RAM (yes, I know Toad only
needs/wants 32bit). My databases haven’t changed. Today’s query
returns about 1600 rows, whole table is about 160mb.

Any suggestions on figuring out if some program is leaking memory or using and
not releasing? Win Task Manager tells me who is using the most with top 3 being
Toad=1.5G, then svchost=143M, and MSOutlook=90M.

I’ve not rebuilt this PC in 13 months so I know it’s due, but I hate
the downtime when I have to rebuild.

Deborah M Flad, DBA
Delaware Children’s Department, State of Delaware
1825 Faulkland Rd, Wilmington DE 19805
Office: 302.633.2694 deborah.flad@state.de.us Emergencies: 302.528.3652 Txt:
www.vtext.com
Our website: www.kids.delaware.gov
How am I doing? Email my manager Harold Miller at Harold.Miller@state.de.us with
any feedback.
“Please consider your environmental responsibility before printing this e-mail”


Confidentiality Notice – This electronic mail transmission and any
attachment(s) are privileged and confidential and are intended only for the
review of the party to whom it is addressed. If you have received this
transmission in error, please immediately notify the sender and delete the
unintended message received. Unintended transmission shall not constitute waiver
of work product or any other privilege.

Picture (Device Independent Bitmap) 1.jpeg
Picture (Device Independent Bitmap) 1.jpeg


#2

Are you running with F5 or F9?

On Nov 24, 2010, at 6:40 PM, “Flad Deborah M. (DSCYF)” <
Deborah.Flad@state.de.us > wrote:

Anyone getting (more) “out of memory” errors with TFO 10.6.1.3? I’m at
point where I can hardly run some queries that ran fine in older Toads.
I’m running Win7 64bit with 8G RAM (yes, I know Toad only needs/wants
32bit). My databases haven’t changed. Today’s query returns about 1600
rows, whole table is about 160mb.

Any suggestions on figuring out if some program is leaking memory or using
and not releasing? Win Task Manager tells me who is using the most with top
3 being Toad=1.5G, then svchost=143M, and MSOutlook=90M.

I’ve not rebuilt this PC in 13 months so I know it’s due, but I hate the
downtime when I have to rebuild.

Deborah M Flad, DBA
Delaware Children's Department, State of Delaware
1825 Faulkland Rd, Wilmington DE 19805
Office: 302.633.2694 deborah.flad@state.de.us Emergencies: 302.528.3652 Txt:
www.vtext.com
Our website: www.kids.delaware.gov
How am I doing? Email my manager Harold Miller at Harold.Miller@state.de.us
with any feedback.
 "Please consider your
environmental responsibility before printing this e-mail"

Confidentiality Notice – This electronic mail transmission and any
attachment(s) are privileged and confidential and are intended only for the
review of the party to whom it is addressed. If you have received this
transmission in error, please immediately notify the sender and delete the
unintended message received. Unintended transmission shall not constitute
waiver of work product or any other privilege.

Picture (Device Independent Bitmap) 1.jpeg


#3

I always recommend that people use Process Explorer rather than Windows Task
Manager.

This is and was a great freeware program that was by another company until
Microsoft acquired them – because their tools were even better than MS
tools J

There are many column you can add to the display and great detailed pop-ups
about what each process is doing. I recommend gathering any other info here that
you can – it might help to lead to an answer quicker.
Picture (Device Independent Bitmap) 1.jpeg


#4

I’ve installed Process Explorer hopefully it will help ID source(s) of
problem.

In running queries my tendencity is to hit the “lightining bolt”
– can never remember if it equals F9 or F5. When out-of-mem error starts
happening I go to running SQL using Script Runner. Had out-of-mem err there too
on occasion.

Only way to clear things up is to crash Toad by killing processes and then
rebooting whole PC. If I don’t reboot the out-of-mem appears even sooner.

Deborah M Flad, DBA
Office: 302.633.2694 Emergencies: 302.528.3652
“Please consider your environmental responsibility before printing this e-mail”
image001.gif


#5

I’ve installed Process Explorer hopefully it will help ID source(s) of
problem.

In running queries my tendencity is to hit the “lightining bolt”
– can never remember if it equals F9 or F5. When out-of-mem error starts
happening I go to running SQL using Script Runner. Had out-of-mem err there too
on occasion.

Only way to clear things up is to crash Toad by killing processes and then
rebooting whole PC. If I don’t reboot the out-of-mem appears even sooner.

Deborah M Flad, DBA
Office: 302.633.2694 Emergencies: 302.528.3652
“Please consider your environmental responsibility before printing this e-mail”
Picture (Device Independent Bitmap) 1.jpeg


#6

Can you determine if Toad is causes exhaustion of memory or resources?
windows/Task Manager/Performance has a graph of CPU usage and Physical Memory

when you reboot …boot clean with F5 Safe Mode
dont load on any services (and dont load on spyware)
windows/Task Manager/Performance has a graph of CPU usage and Physical Memory
run toad (you may have to go to TOAD install folder and run toad from command
line)

Run each of the scripts individiually within Toad and report back Total and
Available Physical Memory and
Total and Paged Kernel Memory allocations
Display the SQL script which causes the spike so we can suggest optimised
alternatives

BTW: Please say hello to joe for me!

thanks,
Martin


American Wireshark Operators: do not alter or disrupt this transmission.


#7

Deborah,

One of the “issues” when running queries via F5 is that Toad has to return the
entire result set before it can display it. In addition to the script output,
there is another “copy” in the grid tab and if you have the history tab enabled,
the results are stored there as well. If you’re just running a query to return
the results to a grid, try running it via F9 instead . If you need to run it as
a script, try turning off the history tab to save memory.

Greg
image004.png


#8

Deborah,

One of the “issues” when running queries via F5 is that Toad has to return the
entire result set before it can display it. In addition to the script output,
there is another “copy” in the grid tab and if you have the history tab enabled,
the results are stored there as well. If you’re just running a query to return
the results to a grid, try running it via F9 instead . If you need to run it as
a script, try turning off the history tab to save memory.

Greg
Picture (Device Independent Bitmap) 1.jpeg


#9

Deborah,

One of the “issues” when running queries via F5 is that Toad has to return the
entire result set before it can display it. In addition to the script output,
there is another “copy” in the grid tab and if you have the history tab enabled,
the results are stored there as well. If you’re just running a query to return
the results to a grid, try running it via F9 instead . If you need to run it as
a script, try turning off the history tab to save memory.

Greg
image001.gif


#10

Deborah,

One of the “issues” when running queries via F5 is that Toad has to return the
entire result set before it can display it. In addition to the script output,
there is another “copy” in the grid tab and if you have the history tab enabled,
the results are stored there as well. If you’re just running a query to return
the results to a grid, try running it via F9 instead . If you need to run it as
a script, try turning off the history tab to save memory.

Greg
image003.png


#11

Normally I use “lightning bolt” icon when mousing to run SQL so that
would be F5.

If I’m in a keyboard mood I hit F9 – and thought it was same as
using “lightning bolt” icon.

Blame it on being visually oriented and F9 being on right of F5, I figured
F9=“lightning bolt” icon which is right of the “run db”
icon.

Seems odd that I didn’t have PC memory problem before. Spent this weekend
removing some software and cleaning up my PC and making sure all is updated.
Doing this work I noticed an MSWin malicious software patch for Nov did not and
will not apply and my new AVG 2011 software was flaking out. Eventually I lost
remote access to my PC and went fly fishing(smartest thing I did all weekend!).

This morning I removed my AVG2011 software and re-installed my AVG9 version and
was able to get network and internet working again. Have not done anything about
the MSWin patch.

I have turned off the History tab but using F5 still get OOM err during second
run of my SQL script, if I’m lucky the OOM err shows up during third run
of script. What I saw over weekend was the mem usage would run up on first run
of SQL and stay there and second or third run of script would put it over the
top and throw the OOM err. A complete closing of all things Toad was only thing
that released the memory.

Also today I’ve proven to myself that multiple runs of my SQL script using
F9 are possible (and faster). I won’t be able to watch memory stats and do
screen prints until tonite after work. I also took a Toad Support Bundle when I
got OOM err on the weekend in case I need to send stuff to Quest.

Deborah M Flad, DBA
Office: 302.633.2694 Emergencies: 302.528.3652
“Please consider your environmental responsibility before printing this e-mail”
image001.gif


#12

Normally I use “lightning bolt” icon when mousing to run SQL so that
would be F5.

If I’m in a keyboard mood I hit F9 – and thought it was same as
using “lightning bolt” icon.

Blame it on being visually oriented and F9 being on right of F5, I figured
F9=“lightning bolt” icon which is right of the “run db”
icon.

Seems odd that I didn’t have PC memory problem before. Spent this weekend
removing some software and cleaning up my PC and making sure all is updated.
Doing this work I noticed an MSWin malicious software patch for Nov did not and
will not apply and my new AVG 2011 software was flaking out. Eventually I lost
remote access to my PC and went fly fishing(smartest thing I did all weekend!).

This morning I removed my AVG2011 software and re-installed my AVG9 version and
was able to get network and internet working again. Have not done anything about
the MSWin patch.

I have turned off the History tab but using F5 still get OOM err during second
run of my SQL script, if I’m lucky the OOM err shows up during third run
of script. What I saw over weekend was the mem usage would run up on first run
of SQL and stay there and second or third run of script would put it over the
top and throw the OOM err. A complete closing of all things Toad was only thing
that released the memory.

Also today I’ve proven to myself that multiple runs of my SQL script using
F9 are possible (and faster). I won’t be able to watch memory stats and do
screen prints until tonite after work. I also took a Toad Support Bundle when I
got OOM err on the weekend in case I need to send stuff to Quest.

Deborah M Flad, DBA
Office: 302.633.2694 Emergencies: 302.528.3652
“Please consider your environmental responsibility before printing this e-mail”
image004.png


#13

Normally I use “lightning bolt” icon when mousing to run SQL so that
would be F5.

If I’m in a keyboard mood I hit F9 – and thought it was same as
using “lightning bolt” icon.

Blame it on being visually oriented and F9 being on right of F5, I figured
F9=“lightning bolt” icon which is right of the “run db”
icon.

Seems odd that I didn’t have PC memory problem before. Spent this weekend
removing some software and cleaning up my PC and making sure all is updated.
Doing this work I noticed an MSWin malicious software patch for Nov did not and
will not apply and my new AVG 2011 software was flaking out. Eventually I lost
remote access to my PC and went fly fishing(smartest thing I did all weekend!).

This morning I removed my AVG2011 software and re-installed my AVG9 version and
was able to get network and internet working again. Have not done anything about
the MSWin patch.

I have turned off the History tab but using F5 still get OOM err during second
run of my SQL script, if I’m lucky the OOM err shows up during third run
of script. What I saw over weekend was the mem usage would run up on first run
of SQL and stay there and second or third run of script would put it over the
top and throw the OOM err. A complete closing of all things Toad was only thing
that released the memory.

Also today I’ve proven to myself that multiple runs of my SQL script using
F9 are possible (and faster). I won’t be able to watch memory stats and do
screen prints until tonite after work. I also took a Toad Support Bundle when I
got OOM err on the weekend in case I need to send stuff to Quest.

Deborah M Flad, DBA
Office: 302.633.2694 Emergencies: 302.528.3652
“Please consider your environmental responsibility before printing this e-mail”
Picture (Device Independent Bitmap) 1.jpeg


#14

Normally I use “lightning bolt” icon when mousing to run SQL so that
would be F5.

If I’m in a keyboard mood I hit F9 – and thought it was same as
using “lightning bolt” icon.

Blame it on being visually oriented and F9 being on right of F5, I figured
F9=“lightning bolt” icon which is right of the “run db”
icon.

Seems odd that I didn’t have PC memory problem before. Spent this weekend
removing some software and cleaning up my PC and making sure all is updated.
Doing this work I noticed an MSWin malicious software patch for Nov did not and
will not apply and my new AVG 2011 software was flaking out. Eventually I lost
remote access to my PC and went fly fishing(smartest thing I did all weekend!).

This morning I removed my AVG2011 software and re-installed my AVG9 version and
was able to get network and internet working again. Have not done anything about
the MSWin patch.

I have turned off the History tab but using F5 still get OOM err during second
run of my SQL script, if I’m lucky the OOM err shows up during third run
of script. What I saw over weekend was the mem usage would run up on first run
of SQL and stay there and second or third run of script would put it over the
top and throw the OOM err. A complete closing of all things Toad was only thing
that released the memory.

Also today I’ve proven to myself that multiple runs of my SQL script using
F9 are possible (and faster). I won’t be able to watch memory stats and do
screen prints until tonite after work. I also took a Toad Support Bundle when I
got OOM err on the weekend in case I need to send stuff to Quest.

Deborah M Flad, DBA
Office: 302.633.2694 Emergencies: 302.528.3652
“Please consider your environmental responsibility before printing this e-mail”
image003.png


#15

Normally I use “lightning bolt” icon when mousing to run SQL so that
would be F5.

If I’m in a keyboard mood I hit F9 – and thought it was same as
using “lightning bolt” icon.

Blame it on being visually oriented and F9 being on right of F5, I figured
F9=“lightning bolt” icon which is right of the “run db”
icon.

Seems odd that I didn’t have PC memory problem before. Spent this weekend
removing some software and cleaning up my PC and making sure all is updated.
Doing this work I noticed an MSWin malicious software patch for Nov did not and
will not apply and my new AVG 2011 software was flaking out. Eventually I lost
remote access to my PC and went fly fishing(smartest thing I did all weekend!).

This morning I removed my AVG2011 software and re-installed my AVG9 version and
was able to get network and internet working again. Have not done anything about
the MSWin patch.

I have turned off the History tab but using F5 still get OOM err during second
run of my SQL script, if I’m lucky the OOM err shows up during third run
of script. What I saw over weekend was the mem usage would run up on first run
of SQL and stay there and second or third run of script would put it over the
top and throw the OOM err. A complete closing of all things Toad was only thing
that released the memory.

Also today I’ve proven to myself that multiple runs of my SQL script using
F9 are possible (and faster). I won’t be able to watch memory stats and do
screen prints until tonite after work. I also took a Toad Support Bundle when I
got OOM err on the weekend in case I need to send stuff to Quest.

Deborah M Flad, DBA
Office: 302.633.2694 Emergencies: 302.528.3652
“Please consider your environmental responsibility before printing this e-mail”
image002.png