Friday Jan 09, 2015

NUMA awareness in DB12c and before

Is it just a coincidence that I read about NUMA and OracleDB on public articles 2 days in a row?
1st one is this.

Recommended Reading: Oracle Database 12c NUMA-Related Topics | Kevin Closson's Blog: Platforms, Databases and Storage

impact of NUMA remote memory on a cached Oracle Database workload

Thanks for posting this one.  But NUMA is not only about Linux cgroups.
2nd one is from Oracle employee.

Ask Tom: On Oracle Database In-Memory

scale up to very high memory and CPU capacities on large SMP servers

So, NUMA is relevant to In-Memory and parallel query , too.
NUMA is not relevant only to DB12c and above.
Some functionality in 11gR1 was already NUMA aware. And it may also was in 10g.
Like other functions are,  NUMA awareness can be turned off by parameter so
I wonder how many customer noticed this awareness in 11g.

Tuesday Jan 06, 2015

Database In-MemoryハンズオンとVirtualBox

あけましておめでとうございます。
年をまたいでしまいましたが去年11月27日のセッションの補足です。

Oracle DBA & Developer Days 2014

ハンズオン:リアルタイム分析を可能にするOracle Database In-Memoryの速さを実感!

上記セッションはVirtualBoxゲストにインストールしたOracle DBで実施していましたが
以下のブログで書いた設定をしていなかったことがわかりました。

VirtualBoxゲストでSIMD命令: DB In-Memory (INOUE Katsumi @ Tokyo)

VBoxManage setextradata "VM name" VBoxInternal/CPUM/SSE4.2 1


このセッションで流したSELECT文の1つは上記設定をすることにより
7倍以上高速に結果を返しました。

About

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

Search

Categories
Archives
« April 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
  
       
Today