Hi, I'd like to set up a VM to host an Oracle database with the in-memory columnar option enabled, so I can do some basic performance testing. But I'm unable to figure out if a VM will at least approximate the real life performance. For instance, the in-memory columnar option used SIMD instruction sets (graphics acceleration routines) to help parallelize and improve speed of scans, etc. I'm wondering if a VM will properly support those. I'd hate to run some performance benchmarks and come away disappointed, only to find out that the benchmark didn't really accurately reflect performance because of limitations in the VM. Are there things I'll need to turn on (2d or 3d acceleration options?) that will make the performance more realistic to what I'd see on a real server?
Any ideas / help is appreciated - thanks in advance!
Scott
Using Virtualbox VM with Oracle in-memory columnar option
-
BillG
- Volunteer
- Posts: 5106
- Joined: 19. Sep 2009, 04:44
- Primary OS: MS Windows 10
- VBox Version: VirtualBox+Oracle ExtPack
- Guest OSses: Windows 10,7 and earlier
- Location: Sydney, Australia
Re: Using Virtualbox VM with Oracle in-memory columnar option
I doubt that it would produce anything useful. Performance tests in vms are not reliable and, in addition, the vm uses its own emulated graphics processor, not the graphics processor of the physical machine.
Bill