Page 1 of 1

Using Virtualbox VM with Oracle in-memory columnar option

Posted: 21. Jun 2016, 02:53
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

Re: Using Virtualbox VM with Oracle in-memory columnar option

Posted: 21. Jun 2016, 08:41
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.