AIX

AIX

Connect with fellow AIX users and experts to gain knowledge, share insights, and solve problems.


#Power
#Power
#Operatingsystems
#Servers
 View Only
  • 1.  Oracle db performance question

    Posted 10/16/11 09:52 AM

    Originally posted by: SystemAdmin


    POWER gurus...
    We are evaluating AIX on POWER7 and Linux for our oracle database platforms.
    Oracle seems to be running faster on the Linux on Intel boxes(DL38*) compared to the POWER7 for a single query that we tried to bench mark.
    Env: Oracle 11.2.0 on AIX 6.1 and RHEL 5.6. Identical database instance and Oracle execution plan were imported on both boxes.
    Has anyone done this kind of testing and seen similar results or we missing some critical system tuning or optimization?
    #AIX-Forum


  • 2.  Re: Oracle db performance question

    Posted 10/17/11 11:39 AM

    Originally posted by: alethad


    Have you tuned the AIX according to the AIX & Oracle documetation?

    There is a very good RedBook on tuning AIX & Oracle. I believe it has been updated for AIX 6.1. It has been linked on this forum many times. You can search the Redbooks. It is very easy to find.

    I keep it on hand for reference no matter what version of AIX or Oracle I have. It's still very useful.

    Good luck.
    #AIX-Forum


  • 3.  Re: Oracle db performance question

    Posted 10/17/11 03:10 PM

    Originally posted by: Holgervk


    I have noticed several times that x86 is quite good in integer computing and 1-2 cpu systems with few tasks parallel.
    Power is good in floating point and systems with many cpu and many tasks in parallel.

    You cannot have both.
    #AIX-Forum