Re: Where is Oracle’s Grid ?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 30 Dec 2003 10:31:17 -0800
Message-ID: <1072808984.413302@yasure>

Niall Litchfield wrote:

> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message

>>If you think 10g, or 100z, is going to give you access to compiled code
>>written by another vendor you are begging for disappointment. No product
>>other than a decompiler will do that.

>
>
> Well you'd have thought so. However in at least limited circumstances (and
> from 8i) Oracle can intercept the sql that the application sends it, and
> rewrite it and execute the rewritten code, this is all that is needed
> (mostly). Those cases are stored outlines and materialized view query
> rewrite. The tuning tool that leccotech sell (can't recall the name)
> automates the 'tuning' process of trying hundreds of possible ways of
> rewriting the queries to select the 'best' one. So it is certainly
> *possible* for Oracle to provide something like Nuno suggests, at least in
> theory by preprocessing the sql passed from the app and running an
> alternative formulation that it expects to perform better.

You are correct. Though it seems a lot of people are stuck with 8.1.6 or other old versions because the vendors threaten desupport if they upgrade. And then there's the rebuild your indexes nonsense too. I personally hope Larry takes PeopleSoft down quickly and puts their front-end code out of its misery.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Tue Dec 30 2003 - 12:31:17 CST