Oracle in an AIX LPAR
From: John Smith <john40855_at_gmail.com>
Date: Wed, 4 Mar 2015 08:32:14 -0600
Message-ID: <CALh2JyvD8c9J2CHVWUxrZZ1_67w_Axb-tEpMF6RPuCvhU4SRYg_at_mail.gmail.com>
Hi. We do not have a lot of experience running Oracle on AIX, but we recently became responsible for an Oracle database in an I series LPAR.
Date: Wed, 4 Mar 2015 08:32:14 -0600
Message-ID: <CALh2JyvD8c9J2CHVWUxrZZ1_67w_Axb-tEpMF6RPuCvhU4SRYg_at_mail.gmail.com>
Hi. We do not have a lot of experience running Oracle on AIX, but we recently became responsible for an Oracle database in an I series LPAR.
We see that the partition is consistently running at over 50% cpu usage, but according to OEM the actual Oracle percentage of that is only about 20 %.
Also, when we look at the thread usage in NMON and TOPAS, we see that Oracle appears to be using only 1 thread per CPU almost all the time. There are a very few occasions when additional threads are used, but the usage outside the primary thread is very small. We have verified that SMT is enabled.
This is oracle 11.2.0.4 on AIX 6.1 Is anyone familiar enough with Oracle on AIX to give us an idea on what to look at? Or is this normal behavior?
Thanks for any help you can provide.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 04 2015 - 15:32:14 CET