I have looked into TimesTen and In-Memory recently. They claim they use SIMD (Single instruction, multiple data) to speed up queries. We use HP DL380 G9 Servers for our DB. Since This series are limited to the Intel Core architecture, It can't benefit from more than 64 CPU cores (32 physical w/ hyperthreading) which Linux kernel 4 (Oracle Linux 7) can provide, opposite to the AMD64's HA which scales fine.
The question is: Can Oracle utilize some sort of GPU parallelism on the box, as OpenCL2 allows shared memory architecture? Is there a way to define GPU cores or compute units as processing units for Oracle?
Best Answer
Any application that uses GPUs for processing has to be custom-written to access the GPU's processing power. Where GPUs shine are in floating point arithmetic, something that is low on the list of database operations, so no, no database software is likely to harness GPUs for processing.