Minimize
Blogger List

Johannes Ahrends
Toad and Oracle

Ben Boise
Toad SC Discussions

Kevin Dalton
Benchmark Factory

Steven Feuerstein
PL/SQL Obsession

Devin Gallagher
Toad SC discussions

Stuart Hodgins
JProbe Discussions

  Henrik "Mauritz" Johnson
Toad Tips & Tricks on the "other" Toads
  Mark Kurtz
Toad SC discussions
  Michael Lumbard
Toad SC discussions
Daniel Norwood
Toad for Data Analysts,
Toad Extension for Visual Studio
Debbie Peabody
Toad for Data Analysts
Gary Piper
Toad Reports Manager
John Pocknell
Toad for Oracle, JProbe
Kuljit Sangha
Toad SC discussions
Bert Scalzo Indicates Oracle ACE status
Toad for Oracle, Data Modeling, Benchmarking
Jeff Smith
Toad product family
Richard To
SQL Optimization
Jim Wankowski
DB2 - LUW and z/OS
John Weathington
  Toad Data Modeler Opens in a new window
Data Modeling
 
  Real Automated Code Testing for Oracle
Quest Code Tester blog
 
Minimize
Blog Tags
toad for oracle (122)
oracle (62)
plsql (46)
sql optimization (37)
toad for data analysts (28)
code tester (19)
toad for ibm db2 (13)
automation (11)
batch optimizer (10)
virtualization (10)
schema browser (9)
toad for sql server (9)
data grid (8)
sql (8)
sql editor (8)
toad data modeler (8)
benchmark factory (7)
excel (7)
query builder (7)
report manager (7)
toad extension (7)
visual studio (7)
11g (6)
configuration (6)
freeware (6)
health check (6)
vmware (6)
connect (5)
dba module (5)
er diagrammer (5)
F4 (5)
linux (5)
refactoring (5)
spotlight (5)
unicode (5)
compare (4)
debugger (4)
export (4)
formatter (4)
make code (4)
rman (4)
strip code (4)
benchmark (3)
bfscript (3)
bulk collect (3)
code templates (3)
code xpert (3)
database browser (3)
db2 (3)
notebook (3)
oem (3)
RAC (3)
session browser (3)
speed (3)
sql optimizer (3)
toad for mysql (3)
tpc-c (3)
9.7 (2)
alert log (2)
app designer (2)
awr (2)
code insight (2)
code snippets (2)
collection (2)
compare and sync (2)
compliance (2)
data generator (2)
data warehouse (2)
database explorer (2)
database monitor (2)
explain (2)
forall (2)
ftp (2)
group execute (2)
handbook (2)
installation (2)
job scheduler (2)
multi-task (2)
nested table (2)
os command (2)
profiler (2)
recovery (2)
release history (2)
save as (2)
schema compare (2)
sql recall (2)
stats pack (2)
subversion (2)
team coding (2)
trace file browser (2)
while loop (2)
10g (1)
64 bit (1)
7zip (1)
action (1)
addm (1)
alter (1)
ansi join (1)
array (1)
ccleaner (1)
code coverage (1)
code road map (1)
CRON (1)
cursor for loop (1)
data browser (1)
data subset (1)
database probe (1)
dbms_flashback (1)
dbms_profiler (1)
ddl (1)
feuerstein (1)
filezilla (1)
flash drive (1)
flow control (1)
for loop (1)
group policy manager (1)
hints (1)
import (1)
index (1)
inheritance (1)
invoker rights (1)
ipad (1)
java (1)
latency (1)
log switch (1)
logical model (1)
ltrim (1)
master-detail browser (1)
monitor (1)
multi-select (1)
naming standards (1)
network (1)
object explorer (1)
OEBS (1)
package (1)
parser (1)
partitioning (1)
performance (1)
pragma (1)
project manager (1)
RAT (1)
revo (1)
REXEC (1)
schema report (1)
script manager (1)
search (1)
set operator (1)
sga (1)
slow (1)
sonarsource (1)
source control (1)
space projection (1)
sql monitor (1)
sql navigator (1)
sql script (1)
sql tracker (1)
sql*plus (1)
standards (1)
statistics (1)
stored procedure (1)
string parser (1)
sub-model (1)
sub-type (1)
synch (1)
synchback (1)
TELNET (1)
toad (1)
trace (1)
unit test (1)
unix (1)
usb (1)
utility (1)
v10 (1)
v9.5 (1)
version control (1)
waits (1)
workload replay (1)
workspace (1)
xml (1)
 
WELCOME, GUEST
 
 

Blogs
Toad and Database Commentaries

Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies.  Have some views of your own to share?  Post your comments!  Note:  Comments are restricted to registered Toad World users.

Do you have a topic that you'd like discussed?  We'd love to hear from you.  Send us your idea for a blog topic.


Jan 21

Written by: Bert
Wednesday, January 21, 2009 6:39 AM  RssIcon

We don’t get this particular question per se as often as one would expect, but we do see enough user problems where this fundamental issue becomes the underlying question to answer for problem resolution. Below is a chart for the release dates for both Toad and Oracle. The “blue highlighted” dates are when Oracle first releases a major new version, such as Oracle 10g in January of 2004. But it’s the “red highlighted” dates that are more significant – as these are what Oracle calls the “terminal release” for a database version, such as 10.2.0.4. That’s the version Oracle treats as the mainstream one that it expects its users to standardize upon – especially for support purposes. In fact an Oracle tech support call where you’re not on the terminal release probably has an above average likelihood of ending with the advice to upgrade to see if that fixes it. Thus look again below, there are four key Oracle versions of which one should be the version that your database server is on. Also note that both Oracle 8i and 9i are essentially unsupported products at this time for most people (unless you have a specific and special extended support agreement with Oracle – and these are neither cheap nor common, so don’t just say yeah we have that).
 
So what version of Toad should you be using? That’s easy – one that came out around the time (and preferably after) your database terminal release version. So that’s why I’ve highlighted four Toad versions in red boxes below. If you’re trying to use Toad 7.6 with and Oracle 9i, 10g or 11g database – then you’re just asking for problems. Stay current on your maintenance and Toad upgrades are free. Don’t live dangerously – Toad 9.6 or 9.7 should be your standard for most cases these days. Happy Toad’ing to you all …..

 

5 comment(s) so far...


Re: What Version of Toad Should We Use?

I like 9.6; apart from a couple of annoying bugs (menus sticking around after you've clicked on the drop down button and not disappearing when you click off them (use Alt instead) and CLOBS causing the col width to go wide when it didn't use to in 9.0 and before), it's the most stable version I've ever used; gone are the frequent crashes and access violations. 9.7 has a few annoying features all of its own that make me want to switch back to 9.6, primarily the fact that search-and-replace no longer seems to work in the editor. *HIGHLY* annoying *{:-( I've already recommended people to go to 9.6 purely for the stability thing!

By Boneist on   Wednesday, January 21, 2009 7:41 AM

Re: What Version of Toad Should We Use?

Have you reported the search and replace issue either to support of via the Toad Yahoo group discussion board - which is manned by our developers? Because it's far better to get issues like that fixed (or learn what's new in their mode of operation) rather than reverting to old versions. Because some day 9.6 may not be viable - so it's better to make the current Toad work the way you need/like so as to stay current :)

By bscalzo on   Wednesday, January 21, 2009 8:04 AM

Re: What Version of Toad Should We Use?

Sure, it's usually better to move forwards than backwards, but 9.7 is also less stable than 9.6 - I'm getting more access violations than before. I've raised Toad's stability and memory-leak proneness to support before now (admittedly when I was on version 9.0.1.8 (iirc) and 9.6 is a country mile away from being as unstable as that!) yet they informed me they'd never ever heard of anything like that about Toad. If that's the case, why does pretty much every developer I've met who's ever used Toad complained or sympathised with me about the poor stability?! If I can work out how to post on the Yahoo group again, I will do re. the 9.7 search and replace, but it's pretty poor that that functionality no longer works, and also that the program is now less stable (although not as bad as previous versions!). That's not going forwards, to me - it's going backwards! (This sounds like I hate Toad; I don't, I think it's a great product, but with some highly annoying "features"! *{;-) )

By Boneist on   Wednesday, January 21, 2009 9:02 AM

Re: What Version of Toad Should We Use?

I'm willing to work with you (and will get the product and development managers involved as well) to fix your concerns. But we cannot read minds. If you truly want the issues fixed, you're going to have to spend time with us to identify what is broken in search and replace, and why you're having so many crashes. We cannot just guess on such issues - we need a divining road (i.e. you). We cannot fix things unless we have details - so if you truly love Toad, this is how to make it better. That's exactly why we have the yahoo group - you get direct access to the toad developers who read, ask questions, and then fix what people tell them. But it requires lots of effort on your part too - because the comment about "if I can get yahoo working again" worries me. Our developers will not be able to address posts that just say I hate the way X now works or it just crashes too much. With no details, they will just ignore the post. But when given help - they bust their behinds to fix stuff - and then make the fixes available in betas far before GA releases so you can test the results (and correct them) far in advance.

By bscalzo on   Friday, January 23, 2009 4:32 AM

Re: What Version of Toad Should We Use?

This might sound like a silly question, but did you UPGRADE your previous version of Toad or do a complete new install? Support sometimes recommends you do this if you have stability issues so that you're not carrying over files from successive previous versions of Toad and possibly causing problems with your current Toad. Toad 9.7 is our most stable release to date (based on far fewer support cases) so I'm concerned that you are having problems. John Pocknell

By Pockers on   Tuesday, January 27, 2009 7:14 AM
Search Blog Entries