Skip to main content

Performance and Provisioning for Virtualized Oracle

EMC (VMware) has a great technical webcast and PDF online about Performance and Provisioning for Virtualized Oracle. I highly recommend you listen to it or read the sheets. Very informative if you want to use virtualized Oracle databases in a production environment.

Most set-ups of virtualizing Oracle databases on VMware fail because storage I/O becomes a bottleneck. It turns out, 50% of all surveyed set-up had storage configured wrong. The problems has to do with storage queues in the VM and subsequently on the ESX host. Additionally, vSphere 4.1 introduces features (SIOC) to optimize the I/O better to the SAN and para virtualized SAN drivers can further reduce latency and increase throughput.

Then the webcast also mentions Oracle's "native" NFS client (dNFS, PDF) inside the database kernel. This reduces the CPU overhead and latency normally observed on NFS client in the OS. By using Oracle's native NFS client, you can use shared storage in a grid computing environment more easily and the same way on Windows as well as Linux.

EMC VMAX SAN box has a feature called FAST VP which can optimize and distribute your storage needs from all-SAN to a mix of SSD, SATA and SAN where and when needed.

Very interesting read and much stuff to think about your own VMware set-up when using Oracle software.

Comments

Popular posts from this blog

Preventing PuTTY timeouts

Just found a great tip to prevent timeouts of PuTTY sessions. I'm fine with timeouts by the host, but in our case the firewall kills sessions after 30 minutes of inactivity... When using PuTTY to ssh to your Linux/Unix servers, be sure to use the feature to send NULL packets to prevent a timeout. I've set it to once every 900 seconds, i.e. 15 minutes... See screenshot on the right.

Tuning the nscd name cache daemon

I've been playing a bit with the nscd now and want to share some tips related to tuning the nscd.conf file. To see how the DNS cache is doing, use nscd -g. nscd configuration: 0 server debug level 26m 57s server runtime 5 current number of threads 32 maximum number of threads 0 number of times clients had to wait yes paranoia mode enabled 3600 restart internal passwd cache: no cache is enabled [other zero output removed] group cache: no cache is enabled [other zero output removed] hosts cache: yes cache is enabled yes cache is persistent yes cache is shared 211 suggested size 216064 total data pool size 1144 used data pool size 3600 seconds time to live for positive entries 20 seconds time to live for negative entries 66254 cache hi...

Dell Linux - OMSA Hardware Monitoring

Just getting started using Dell's OpenManage Server Administrator (OMSA) on our Oracle Linux platform. There are some confusing instructions going around so it's not immediately clear what to do, hence my blogging here. :) There is a site on Dell - Hardware Monitoring , as well as a wiki with instruction on how to setup their OMSA tooling using yum or up2date. [update]My first update for their instructions: be sure your server has Internet access, as most servers will use a proxy or so. use export http_proxy=http://yourproxy.example.com:port to configure it just for the session, and setup up2date to use an HTTP proxy by editing the settings in /etc/sysconfig/rhn/up2date .