Re: Why does Oracle cost so much?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 28 May 2004 17:23:07 -0700
Message-ID: <1085790194.619760@yasure>

Hans Forbrich wrote:

> Daniel Morgan wrote:
>
>

>>>>>I'm not so sure how the scalability part translates. I'll leave
>>>
>>>Are you saying - you're not sure whether size matters?
>>
>>Scalability could refer to many different metrics. You make an allusion
>>to only one of them. Another measure might be how many other women are
>>in the male's life at one time. And having a vivid imagination I can
>>think of a few more.

>
>
> Note that I did not specify the unit of measurement. You read the allusion
> [to only one] into my question.
>
> For example Size of Shared Pool, as you use, is valid _in this instance_ as
> a potential measure of scalability even if the measure is non-traditional.
> I can think of a few others.
>
> As an aside, in this case I suspect that the query may have to be set up
> very carefully and possibly using some explicit locking, even if it does
> inhibit concurrency. I'd also have to suggest watching the SORT_AREA_SIZE
> very carefully. Of course that depends entirely on the data set - as often
> discussed, it's important to know your data.
>
> One challenge I see is in definition of performance, as 'fastest completion'
> might not be the most desirable objective. I guess that proves the
> importance of a documented SLA.
>
> /Hans

So it appears that in this environment serialization might be considered a positive while clustering and sharing blocks a negative?

-- 
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 Fri May 28 2004 - 19:23:07 CDT