Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Where is Oracle’s Grid ?

Re: Where is Oracle’s Grid ?

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Wed, 31 Dec 2003 11:32:13 +1100
Message-ID: <3ff219cf$1$18690$afc38c87@news.optusnet.com.au>


"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1072810464.715634_at_yasure...

> The CBO does this CJ
> > replacement often enough when join columns are of different data types, as
> > you likely are aware of.
>
> I was referring to the garbage code written into many of these
> third-party product's front-ends.

Well, yes. That is a big part of the garbage code I've seen over the years. It's well known that predicates involving different data types cause implicit data conversions. It's also well known that the optimiser (or is it the parser?) will 9 times out of 10 do the wrong implicit conversion, ie, the one that will stop an index from working. Yet, these 3rd parties still insist on coding that way...

Mind you, about time Oracle fixed that little trait of picking the wrong conversion. Yes, I know FBI fixes this but not everyone does or can use them. Much better if the parser/optimiser avoided the problem in the first place. As recent as 8ir3 it was still doing it. Haven't tried with 9i yet, I'm the one designing and coding with this one and the problem is of course designed out.

> I'd guess because most products are not using TAF and not trapping
> commits and not written by people that understand how to write for
> fail-over. It is absolutely Oracle's fault that this includes Oracle
> Forms, Reports, and Apps. It is not their fault that other vendors
> similarly have refused to rewrite their code for fail-over.

Well, it's the nature of the beast nowadays... These multi-tier apps are just glorified ways of making systems database-unaware. With dire consequences for Oracle and its newer features, IMHO.

> Provided one insists on purchasing garbage from vendors that don't
> leverage these abilities. One of the reasons for Amazon's success is
> that they have written all of their own apps and all of their own APIs.
> It is the difference between good management and bad.

Couldn't agree more. Let's hope managers out there start changing their attitude. Otherwise this industry is truly down the gurgler as far as quality goes.

> Now I understand what you want. Hmmmm. I think it would be far easier to
> just buy good software in the first place ... or write it yourself.
>

I wish...

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
Received on Tue Dec 30 2003 - 18:32:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US