Re: Which processors run SIMD to take advantage of Oracle 12c in memory option parallel processing

On Sun, 24 Aug 2014 20:04:25 -0700, zigzagdna wrote:

> My company has linux servers which use AMD Opteron(TM) Processor 6276
> We are running Red Hat enterprise Linux 6.x. Do these processor support
> SIMD which can be used with Oracle 12c in memory database option to
> access column store very fast by doing parallel processing. I did google
> search, but could not find this information; so hoping experts here can
> answer my question.

Zigzagdna, you have confused things completely, not for the first time. Oracle 12c in-memory doesn't option require SIMD, which is also known as "vector processing". Vector processing is very handy when dealing with large floating point matrices but plays no role in resolving queries by using in-memory option. Oracle in-memory option uses smart hashing algorithms and statistic methods like Bloom filters which are not aided by the vector processing. And RH Linux 6.x can use any Opteron CPU. In other words, the answer to your question is "42".

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com