What are the meanings of the options for "AIX Instance CPU Mode"?
The two options are OSMODE and SQLMODE.
This is found under Administration, Agent Properties, DB_Oracle, DB_Oracle.
In some AIX systems the system CPU in the host dashboard was found to be much higher than the Oracle CPU in the Oracle dashboard on virtual hosts (LPAR) where just a single Oracle DB is running. This occurs in AIX environments only, and has not been seen in Linux or Windows.
We determined that this was due to an Oracle bug, 7612642 "OEM CPU DOES NOT REFLECT AIX OS CPU FROM SYSADMINS"
Oracle's description for the issue is "OEM's CPU Utilization (%) does not match up to OS Cpu Utilization from our OS tools. OEM's CPU Utilization is less than half to a third at peak times."
To address this issue, a new ASP parameter was added and called: 'AIX Instance CPU Mode' (agmAixInstanceCpuMode). Once this parameter is set to 'OSMODE' and the monitored platform is AIX - the instance CPU is calculated in a different way fetching the CPU for the Oracle PIDs and determining the total CPU through the delta CPUs in seconds.
