Hi,
I'm having some problems with a JDBC app and a Oracle instance on the same XP guest...
Host: Ubuntu 8.10 (Linux 2.6.31) 64-bit / Q6600 (quad) CPU / VMWare Workstation 7.1
Guest: XP SP2 / Oracle 10.2.0.1 / jvm app / preallocated disc / 1 CPU allocated
First, I see that the CPU on Windows is 100% all the time when the Java app is using a jdbc connection. 98% of this is system and oracle.exe is the top CPU user.
I break down to Linux, on a quad-core; about 24% is system also (explains the 98% on Windows that is single core); and vmware-vmx is the CPU hog with always the same PID.
I do a "strace -c" to find out what this vmware-vmx process is doing with Linux for about 20 seconds...
% time seconds usecs/call calls errors syscall
99.95 20.990427 14050 1494 poll
poll() is doing the trouble, okay, what fds are really watched??? I do a standard strace output to find out what fds are actually used :
lrwx------ 1 root root 64 2010-05-27 19:50 65 -> socket:[29401]
lrwx------ 1 root root 64 2010-05-27 19:50 58 -> socket:[29395]
lrwx------ 1 root root 64 2010-05-27 19:50 40 -> anon_inode:[eventfd]
lr-x------ 1 root root 64 2010-05-27 19:50 50 -> pipe:[29382]
lrwx------ 1 root root 64 2010-05-27 19:50 131 -> /dev/vmci
lrwx------ 1 root root 64 2010-05-27 19:50 101 -> anon_inode:[eventfd]
lrwx------ 1 root root 64 2010-05-27 19:50 66 -> /dev/vmmon
lrwx------ 1 root root 64 2010-05-27 19:50 185 -> socket:[29441]
lrwx------ 1 root root 64 2010-05-27 19:50 61 -> socket:[29387]
lrwx------ 1 root root 64 2010-05-27 19:50 57 -> anon_inode:[eventfd]
lrwx------ 1 root root 64 2010-05-27 19:50 7 -> anon_inode:[eventfd]
lrwx------ 1 root root 64 2010-05-27 19:50 102 -> /dev/vmmon
lrwx------ 1 root root 64 2010-05-27 19:50 150 -> anon_inode:[eventfd]
Wow, none of this is real IO; I mean: that involves the SATA discs. I'm pretty much out of ideas. Is it a combination of Ubuntu Kernels + Windows Oracle install??? why poll() would do the trouble?
I have a guest with Oracle Linux and Oracle DB + Java app and I have none of these problems with the host.
Where should I look to diagnose this problem?
Thanks & Regards,
Pascal.
