Using Virtualbox VM with Oracle in-memory columnar option
Posted: 21. Jun 2016, 02:53
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
Any ideas / help is appreciated - thanks in advance!
Scott