Using Virtualbox VM with Oracle in-memory columnar option

This is for discussing general topics about how to use VirtualBox.
Post Reply
SPowell42
Posts: 1
Joined: 21. Jun 2016, 02:47

Using Virtualbox VM with Oracle in-memory columnar option

Post by SPowell42 »

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
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

Post by BillG »

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
Post Reply