Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Why does Oracle cost so much?
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?
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 Received on Fri May 28 2004 - 08:16:32 CDT
![]() |
![]() |