I would check for any difference in:
- Machine BIOS setup: hyper-thread, energy configuration, etc
- Kernel parameters in /etc/sysctl.conf
- Limits in /etc/security/limits.conf
If both servers are using the same HW, OS and Oracle SW, there is no point
in being an Oracle limitation.
And the basics you probably already checked: disk speed and RAID
configuration where the data files are stored, database parameters,
concurrent processes, alert log errors, /var/log/messages errors, network
between app server and db server, network errors...
On 11 August 2017 at 03:34, Mladen Gogala <gogala.mladen@xxxxxxxxx> wrote:
On 08/10/2017 12:46 PM, Henry Poras wrote:
Thanks for all of the suggestions. Here is where I am so far:A pointed question: on the server which uses more CPU, how much CPU is
spent in kernel mode, as opposed to the user mode? Have you tried doing
something like sar -u 3 20? If you have, can you post the result? You can
also check sar history files in the /var/log/sa directory.
--
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com
--
//www.freelists.org/webpage/oracle-l