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

Hi
In case you are CPU bound at times, if there are more cpu waits, then i think that if you upgrade the number of cpus, and your disk controllers can not match that activity of reads/writes the problem would be compounded rather than mitigated. Check your disk i/o activity with the available controllers before decideing to upgrade. Also i believe that MTS (multi threaded server) helps alleviate the problems with the memory rather than cpu activity. Also in AIX(RS/6000-Aix 4.3.3) the asynchronous processes do consume more of cpu time on behalf of their parent oracle processes. Kindly correct me in my above suggestions if they are wrong.

Regards,
Ashok

"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.
>
> 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.
>
> 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 - 00:59:10 CDT