0 Replies Latest reply on May 27, 2010 6:58 PM by pasgaut

    High system CPU with Oracle XP guest and Linux 64bit host

    pasgaut Lurker

      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.