Oracle SQL Developer and TOAD

While doing some development with some large tables recently, I found that Oracle's SQL Developer seems to die out after trying to export > 100k records. It doesn't really error out, it just dies, without error, and consumes memory. I have only done some limited trials with large data volumes, but ended up going to good old SQL*Plus to get the proper output, as I was pressed for time. I plan on doing some more detailed analysis to see what the magic number of records is, and if there is any logging I can turn on to see what is really happening.

I would normally use Quest Software's TOAD for Oracle for this type of work, but I was using a customer supplied laptop, and did not want to install any unlicensed software. I have found that SQL Developer is good for some things, and shows a lot of promise, but for any real hardcore development or database work, I find myself turning to TOAD most often.

I also have a few MySQL databases that I need to maintain and run reports/queries against, and use TOAD for MySQL Freeware whenever I need to do some work on it. I have a few monthly reports I run to extract data, and have TOAD set up to run them for me, and really like the feature to export the results directly into a running Excel instance at the highlighted cell.