Re: Oracle 8i on RS/6000 AIX question.

"Howard Rogers" <Howard.Rogers_at_oracle.com> wrote in message news:<zwjz8.16$707.267_at_news.oracle.com>...
> Oracle 8i on RS/6000 AIX question.Is the problem one of length of
> transactions causing blocking, or concurrency of access? If it's
> long-running transactions, processor speed would help. But I suspect it's
> concurrency issues, in which case more processors is likely to be the better
> way forward.

I would second this.  

> On the other hand, have you implemented a Multi-threaded Server
> configuration yet or not? It's quite conceivable that a properly-implemented
> MTS configuration would make far more effective use of the resources you
> already posess, and you wouldn't have to upgrade anything.

Correct me if I'm wrong but MTS wouldn't help with cpu-bound system. MTS makes a better use of memory, os resources (proc table) but as far as cpu is concerned it's an overhead. After all it takes cycles to dispatch requests/responces.

Regards,
Igor

> There really isn't enough information to go on to offer meaningful advice
> beyond these basic generalities.
>
> Regards
> HJR
>
> (PS. HTML posting is not exactly recommended)
>
> ========
> "Todd Parnell" <TParnell_at_sauder.com> wrote in message
> news:D577E02F49A4A8498167BA5E41424D4703C5B674_at_expf1...
> We are using a dual-processor RISC machine and we are CPU bound at certain
> times. We are a pretty standard OLTP type of operation.
> The question has come up, would we be better off doubling the processor
> speed or doubling the number of processors?
> As far as Oracle is concerned, the latter is more expensive.
> I would appreciate hearing from anyone else who has encountered this.
> Thanks,
> Todd Parnell
Received on Tue Apr 30 2002 - 02:37:00 CDT