Oracle InMemory uses SSE4.2 extensions to run SIMD.
However, by default, Virtualbox(VBOX) may not configure this. You can verify if the extensions are enabled
by checking the flag in cpuinfo as follows in your Linux guest OS
cat /proc/cpuinfo | grep sse4
If it is not set, then no rows will be returned.
you have to do the following tweak to enable it.
1) Shutdown the guest VM, and the GUI VM manager.
2) cd to VM home directory.
eg. cd D:\software\virtualbox
3) run the following command Allowing VirtualBox to pass the SSE 4.2 extensions
( supported in VirtualBox starting in Versions 4.3.8)
eg.
D:\software\virtualbox>VBoxManage setextradata "VM name" VBoxInternal/CPUM/SSE4.2 1
Where "VM Name" is the name of your guest Linux VM.
4) start the GUI VManager and start the guest OS.
5) verify if the flag is set.
cat /proc/cpuinfo | grep sse4
[oracle@bigdatalite ~]$ cat /proc/cpuinfo | grep sse4
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx rdtscp lm constant_tsc rep_good nopl pni ssse3 sse4_2 lahf_lm
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx rdtscp lm constant_tsc rep_good nopl pni ssse3 sse4_2 lahf_lm
To see if the library is linked dynamically , you can run the following
ps -ef | grep ora_p | awk '{system ( "pmap "$2 " |grep libshpk " ) ; print "-->"$8 }'
[oracle@bigdatalite ~]$ ps -ef | grep ora_p | awk '{system ( "pmap "$2 " |grep libshpk " ) ; print "-->"$8 }'
00007f732897d000 1500K r-x-- /u01/app/oracle/product/12.1.0/dbhome_1/lib/libshpksse4212.so
00007f7328af4000 2044K ----- /u01/app/oracle/product/12.1.0/dbhome_1/lib/libshpksse4212.so
00007f7328cf3000 72K rw--- /u01/app/oracle/product/12.1.0/dbhome_1/lib/libshpksse4212.so
-->ora_pmon_orcl
00007f8e01a71000 1500K r-x-- /u01/app/oracle/product/12.1.0/dbhome_1/lib/libshpksse4212.so
00007f8e01be8000 2044K ----- /u01/app/oracle/product/12.1.0/dbhome_1/lib/libshpksse4212.so
00007f8e01de7000 72K rw--- /u01/app/oracle/product/12.1.0/dbhome_1/lib/libshpksse4212.so
00007f732897d000 1500K r-x-- /u01/app/oracle/product/12.1.0/dbhome_1/lib/libshpksse4212.so
00007f7328af4000 2044K ----- /u01/app/oracle/product/12.1.0/dbhome_1/lib/libshpksse4212.so
00007f7328cf3000 72K rw--- /u01/app/oracle/product/12.1.0/dbhome_1/lib/libshpksse4212.so
-->ora_pmon_orcl
00007f8e01a71000 1500K r-x-- /u01/app/oracle/product/12.1.0/dbhome_1/lib/libshpksse4212.so
00007f8e01be8000 2044K ----- /u01/app/oracle/product/12.1.0/dbhome_1/lib/libshpksse4212.so
00007f8e01de7000 72K rw--- /u01/app/oracle/product/12.1.0/dbhome_1/lib/libshpksse4212.so
No comments:
Post a Comment
Feedback welcome