Thursday, August 28, 2014

cygwin wget over corprate proxy

liqy@testserver1 /bin
$ export http_proxy="http://domain1\liqy:password1@proxy1:8080/"

$ echo $http_proxy
http://domain1\liqy:password1@proxy1:8080/

liqy@testserver1 /bin
$ wget http://apt-cyg.googlecode.com/svn/trunk/apt-cyg
--2014-08-26 11:10:43--  http://apt-cyg.googlecode.com/svn/trunk/apt-cyg
Resolving proxy1 (proxy1)... 10.33.90.91
Connecting to proxy1 (proxy1)|10.33.90.91|:8080... connected.
Proxy request sent, awaiting response... 200 OK
Length: 10572 (10K) [text/plain]
Saving to: ‘apt-cyg.1’

100%[======================================>] 10,572      --.-K/s   in 0.001s

2014-08-26 11:10:43 (17.6 MB/s) - ‘apt-cyg.1’ saved [10572/10572]

Friday, August 22, 2014

impact of SYS password change to data guard

when SYS password is changed, password file changed accordingly.

If it is not sync to standby site, archived log transfer failed as shown below.

-- at primary site

Wed Aug 20 11:14:24 2014
Archived Log entry 2743 added for thread 1 sequence 5263 ID 0x69704abb dest 1:
Archived Log entry 2744 added for thread 1 sequence 5264 ID 0x69704abb dest 1:
Wed Aug 20 11:14:47 2014
Starting background process SMCO
Wed Aug 20 11:14:47 2014
SMCO started with pid=33, OS id=15785
Wed Aug 20 11:15:44 2014
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
      returning error ORA-16191
------------------------------------------------------------
PING[ARC1]: Heartbeat failed to connect to standby 'dg'. Error is 16191.
Wed Aug 20 11:16:45 2014
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
      returning error ORA-16191
------------------------------------------------------------
PING[ARC1]: Heartbeat failed to connect to standby 'dg'. Error is 16191.
Wed Aug 20 11:16:56 2014
Thread 1 advanced to log sequence 5266 (LGWR switch)
  Current log# 2 seq# 5266 mem# 0: /u01/oradata/DG/redo02.log
Wed Aug 20 11:16:56 2014
Archived Log entry 2745 added for thread 1 sequence 5265 ID 0x69704abb dest 1:
Wed Aug 20 11:16:57 2014
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
      returning error ORA-16191
------------------------------------------------------------
FAL[server, ARC3]: Error 16191 creating remote archivelog file 'dg'
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance DGS - Archival Error. Archiver continuing.


--at standby site

ARC8: Becoming the 'no FAL' ARCH
ARC1: Becoming the heartbeat ARCH
ARC1: Becoming the active heartbeat ARCH
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
      returning error ORA-16191
------------------------------------------------------------
FAL[client, ARC9]: Error 16191 connecting to dgs for fetching gap sequence




Monday, July 14, 2014

alter system disconnect session for shared server session

Understanding this command can help to kill shared server session, 
e.g. alter system disconnect session '  11, 14521' immediate;


However, this didn't seem to work in my production situation. The session was not gone until we stopped application end. 
Any comments ?

Friday, July 11, 2014

ORA-01114

ORA-00603: ORACLE server session terminated by fatal error
ORA-24557: error 1114 encountered while handling error 1114; exiting server process
ORA-01114: IO error writing block to file 204 (block # 76928)


ERROR at line 1:
ORA-12801: error signaled in parallel query server P037
ORA-01114: IO error writing block to file (block # )
ORA-01114: IO error writing block to file 1527 (block # 3126400)
ORA-27072: File I/O error
Additional information: 4
Additional information: 3126400
Additional information: -1 



Hit above error, even run  a small query irregardless off 300GB TEMP space.

Please refer to my reply here



Monday, June 16, 2014

RMAN-06172

due to backupset is copied from HP-UX to Linux64 platform.

Friday, May 16, 2014

re-create AIX /dev/null

The type of /dev/null was accidentally changed  by command "rm /dev/null*"

Its type should be char device as shown below.

-rw-r--r--    1 root     system    619851909 May 15 14:23 null 2>&1
crw-rw-rw-    1 root     system        2,  2 May 15 14:24 null

after "rm null*" , it became 

-rw-r--r--    1 root     system           41 May 15 14:24 null
-rw-r--r--    1 root     system          190 May 15 14:24 null 2>&1

something like a normal file.

Googled but those solution doesn't work, as I failed to delete /dev/null "file" although there is no error message returned.

e.g.  

rm /dev/null ; mknod -m 0666 /dev/null c 2 2 ; chown root:system /dev/null


So my solution is to reboot the server, and it works for me since this is a test server.
 #ls -l null*
crw-rw-rw-    1 root     system        2,  2 May 15 14:56 null
-rw-r--r--    1 root     system        31458 May 15 14:56 null 2>&1

Tuesday, April 15, 2014

memory bandwith test

I had 2GB x4 memory in my desktop, however recently one of them failed to pass memtest.  Left three 2GB memory can be used temporarily, so I am wondering what exactly DUAL channel memory make sense.

Below are number I tested with mbw .

About mbw

mbw(1)                                                                         General Commands Manual                                                                         mbw(1)

NAME
       mbw - Memory BandWidth benchmark

SYNOPSIS
       mbw [options] arraysize_in_MiB

DESCRIPTION
       mbw determines available memory bandwidth by copying large arrays of data in memory.


The combinations

2GB+2GB DUAL CHANNEL

hmc@hmc-P55A-UD3:~$ mbw 1024
Long uses 8 bytes. Allocating 2*134217728 elements = 2147483648 bytes of memory.
Using 262144 bytes as blocks for memcpy block copy test.
Getting down to business... Doing 10 runs per test.
0 Method: MEMCPY Elapsed: 0.25170 MiB: 1024.00000 Copy: 4068.416 MiB/s
1 Method: MEMCPY Elapsed: 0.26332 MiB: 1024.00000 Copy: 3888.804 MiB/s
2 Method: MEMCPY Elapsed: 0.26424 MiB: 1024.00000 Copy: 3875.294 MiB/s
3 Method: MEMCPY Elapsed: 0.28211 MiB: 1024.00000 Copy: 3629.841 MiB/s
4 Method: MEMCPY Elapsed: 0.27033 MiB: 1024.00000 Copy: 3787.907 MiB/s
5 Method: MEMCPY Elapsed: 0.26815 MiB: 1024.00000 Copy: 3818.801 MiB/s
6 Method: MEMCPY Elapsed: 0.27420 MiB: 1024.00000 Copy: 3734.446 MiB/s
7 Method: MEMCPY Elapsed: 0.26919 MiB: 1024.00000 Copy: 3803.990 MiB/s
8 Method: MEMCPY Elapsed: 0.27002 MiB: 1024.00000 Copy: 3792.326 MiB/s
9 Method: MEMCPY Elapsed: 0.27435 MiB: 1024.00000 Copy: 3732.472 MiB/s
AVG Method: MEMCPY Elapsed: 0.26876 MiB: 1024.00000 Copy: 3810.087 MiB/s
0 Method: DUMB Elapsed: 0.16932 MiB: 1024.00000 Copy: 6047.863 MiB/s
1 Method: DUMB Elapsed: 0.16700 MiB: 1024.00000 Copy: 6131.626 MiB/s
2 Method: DUMB Elapsed: 0.16870 MiB: 1024.00000 Copy: 6070.019 MiB/s
3 Method: DUMB Elapsed: 0.16806 MiB: 1024.00000 Copy: 6093.135 MiB/s
4 Method: DUMB Elapsed: 0.16730 MiB: 1024.00000 Copy: 6120.851 MiB/s
5 Method: DUMB Elapsed: 0.16778 MiB: 1024.00000 Copy: 6103.230 MiB/s
6 Method: DUMB Elapsed: 0.16818 MiB: 1024.00000 Copy: 6088.606 MiB/s
7 Method: DUMB Elapsed: 0.16698 MiB: 1024.00000 Copy: 6132.398 MiB/s
8 Method: DUMB Elapsed: 0.16601 MiB: 1024.00000 Copy: 6168.266 MiB/s
9 Method: DUMB Elapsed: 0.16980 MiB: 1024.00000 Copy: 6030.731 MiB/s
AVG Method: DUMB Elapsed: 0.16791 MiB: 1024.00000 Copy: 6098.414 MiB/s
0 Method: MCBLOCK Elapsed: 0.21192 MiB: 1024.00000 Copy: 4831.944 MiB/s
1 Method: MCBLOCK Elapsed: 0.17160 MiB: 1024.00000 Copy: 5967.227 MiB/s
2 Method: MCBLOCK Elapsed: 0.17416 MiB: 1024.00000 Copy: 5879.617 MiB/s
3 Method: MCBLOCK Elapsed: 0.17381 MiB: 1024.00000 Copy: 5891.559 MiB/s
4 Method: MCBLOCK Elapsed: 0.17415 MiB: 1024.00000 Copy: 5880.124 MiB/s
5 Method: MCBLOCK Elapsed: 0.17529 MiB: 1024.00000 Copy: 5841.781 MiB/s
6 Method: MCBLOCK Elapsed: 0.17485 MiB: 1024.00000 Copy: 5856.515 MiB/s
7 Method: MCBLOCK Elapsed: 0.17552 MiB: 1024.00000 Copy: 5833.960 MiB/s
8 Method: MCBLOCK Elapsed: 0.17847 MiB: 1024.00000 Copy: 5737.627 MiB/s
9 Method: MCBLOCK Elapsed: 0.17409 MiB: 1024.00000 Copy: 5881.846 MiB/s
AVG Method: MCBLOCK Elapsed: 0.17839 MiB: 1024.00000 Copy: 5740.332 MiB/s
hmc@hmc-P55A-UD3:~$ mbw 512
Long uses 8 bytes. Allocating 2*67108864 elements = 1073741824 bytes of memory.
Using 262144 bytes as blocks for memcpy block copy test.
Getting down to business... Doing 10 runs per test.
0 Method: MEMCPY Elapsed: 0.12873 MiB: 512.00000 Copy: 3977.348 MiB/s
1 Method: MEMCPY Elapsed: 0.12578 MiB: 512.00000 Copy: 4070.729 MiB/s
2 Method: MEMCPY Elapsed: 0.12749 MiB: 512.00000 Copy: 4015.938 MiB/s
3 Method: MEMCPY Elapsed: 0.12885 MiB: 512.00000 Copy: 3973.644 MiB/s
4 Method: MEMCPY Elapsed: 0.12719 MiB: 512.00000 Copy: 4025.505 MiB/s
5 Method: MEMCPY Elapsed: 0.12878 MiB: 512.00000 Copy: 3975.680 MiB/s
6 Method: MEMCPY Elapsed: 0.12947 MiB: 512.00000 Copy: 3954.554 MiB/s
7 Method: MEMCPY Elapsed: 0.12625 MiB: 512.00000 Copy: 4055.317 MiB/s
8 Method: MEMCPY Elapsed: 0.12857 MiB: 512.00000 Copy: 3982.174 MiB/s
9 Method: MEMCPY Elapsed: 0.12934 MiB: 512.00000 Copy: 3958.589 MiB/s
AVG Method: MEMCPY Elapsed: 0.12805 MiB: 512.00000 Copy: 3998.579 MiB/s
0 Method: DUMB Elapsed: 0.08313 MiB: 512.00000 Copy: 6159.102 MiB/s
1 Method: DUMB Elapsed: 0.08282 MiB: 512.00000 Copy: 6182.380 MiB/s
2 Method: DUMB Elapsed: 0.08241 MiB: 512.00000 Copy: 6212.612 MiB/s
3 Method: DUMB Elapsed: 0.08278 MiB: 512.00000 Copy: 6184.994 MiB/s
4 Method: DUMB Elapsed: 0.08298 MiB: 512.00000 Copy: 6170.236 MiB/s
5 Method: DUMB Elapsed: 0.08273 MiB: 512.00000 Copy: 6188.583 MiB/s
6 Method: DUMB Elapsed: 0.08374 MiB: 512.00000 Copy: 6114.163 MiB/s
7 Method: DUMB Elapsed: 0.08243 MiB: 512.00000 Copy: 6211.482 MiB/s
8 Method: DUMB Elapsed: 0.08273 MiB: 512.00000 Copy: 6189.181 MiB/s
9 Method: DUMB Elapsed: 0.08272 MiB: 512.00000 Copy: 6189.331 MiB/s
AVG Method: DUMB Elapsed: 0.08285 MiB: 512.00000 Copy: 6180.089 MiB/s
0 Method: MCBLOCK Elapsed: 0.08727 MiB: 512.00000 Copy: 5866.917 MiB/s
1 Method: MCBLOCK Elapsed: 0.08827 MiB: 512.00000 Copy: 5800.385 MiB/s
2 Method: MCBLOCK Elapsed: 0.08897 MiB: 512.00000 Copy: 5754.749 MiB/s
3 Method: MCBLOCK Elapsed: 0.08819 MiB: 512.00000 Copy: 5805.713 MiB/s
4 Method: MCBLOCK Elapsed: 0.08797 MiB: 512.00000 Copy: 5819.901 MiB/s
5 Method: MCBLOCK Elapsed: 0.08767 MiB: 512.00000 Copy: 5839.816 MiB/s
6 Method: MCBLOCK Elapsed: 0.08864 MiB: 512.00000 Copy: 5775.978 MiB/s
7 Method: MCBLOCK Elapsed: 0.08828 MiB: 512.00000 Copy: 5799.728 MiB/s
8 Method: MCBLOCK Elapsed: 0.08821 MiB: 512.00000 Copy: 5804.199 MiB/s
9 Method: MCBLOCK Elapsed: 0.08842 MiB: 512.00000 Copy: 5790.480 MiB/s
AVG Method: MCBLOCK Elapsed: 0.08819 MiB: 512.00000 Copy: 5805.634 MiB/s
hmc@hmc-P55A-UD3:~$ mbw 256
Long uses 8 bytes. Allocating 2*33554432 elements = 536870912 bytes of memory.
Using 262144 bytes as blocks for memcpy block copy test.
Getting down to business... Doing 10 runs per test.
0 Method: MEMCPY Elapsed: 0.06817 MiB: 256.00000 Copy: 3755.373 MiB/s
1 Method: MEMCPY Elapsed: 0.06396 MiB: 256.00000 Copy: 4002.314 MiB/s
2 Method: MEMCPY Elapsed: 0.06331 MiB: 256.00000 Copy: 4043.276 MiB/s
3 Method: MEMCPY Elapsed: 0.06520 MiB: 256.00000 Copy: 3926.140 MiB/s
4 Method: MEMCPY Elapsed: 0.06455 MiB: 256.00000 Copy: 3966.102 MiB/s
5 Method: MEMCPY Elapsed: 0.06359 MiB: 256.00000 Copy: 4025.790 MiB/s
6 Method: MEMCPY Elapsed: 0.06506 MiB: 256.00000 Copy: 3935.071 MiB/s
7 Method: MEMCPY Elapsed: 0.06506 MiB: 256.00000 Copy: 3934.648 MiB/s
8 Method: MEMCPY Elapsed: 0.06614 MiB: 256.00000 Copy: 3870.343 MiB/s
9 Method: MEMCPY Elapsed: 0.06316 MiB: 256.00000 Copy: 4053.327 MiB/s
AVG Method: MEMCPY Elapsed: 0.06482 MiB: 256.00000 Copy: 3949.343 MiB/s
0 Method: DUMB Elapsed: 0.04194 MiB: 256.00000 Copy: 6104.540 MiB/s
1 Method: DUMB Elapsed: 0.04206 MiB: 256.00000 Copy: 6085.964 MiB/s
2 Method: DUMB Elapsed: 0.04207 MiB: 256.00000 Copy: 6084.807 MiB/s
3 Method: DUMB Elapsed: 0.04221 MiB: 256.00000 Copy: 6064.914 MiB/s
4 Method: DUMB Elapsed: 0.04204 MiB: 256.00000 Copy: 6090.018 MiB/s
5 Method: DUMB Elapsed: 0.04180 MiB: 256.00000 Copy: 6124.841 MiB/s
6 Method: DUMB Elapsed: 0.04184 MiB: 256.00000 Copy: 6117.962 MiB/s
7 Method: DUMB Elapsed: 0.04221 MiB: 256.00000 Copy: 6065.057 MiB/s
8 Method: DUMB Elapsed: 0.04243 MiB: 256.00000 Copy: 6033.609 MiB/s
9 Method: DUMB Elapsed: 0.04193 MiB: 256.00000 Copy: 6105.268 MiB/s
AVG Method: DUMB Elapsed: 0.04205 MiB: 256.00000 Copy: 6087.585 MiB/s
0 Method: MCBLOCK Elapsed: 0.04232 MiB: 256.00000 Copy: 6049.149 MiB/s
1 Method: MCBLOCK Elapsed: 0.04271 MiB: 256.00000 Copy: 5993.351 MiB/s
2 Method: MCBLOCK Elapsed: 0.04250 MiB: 256.00000 Copy: 6023.813 MiB/s
3 Method: MCBLOCK Elapsed: 0.04296 MiB: 256.00000 Copy: 5959.170 MiB/s
4 Method: MCBLOCK Elapsed: 0.04243 MiB: 256.00000 Copy: 6032.898 MiB/s
5 Method: MCBLOCK Elapsed: 0.04251 MiB: 256.00000 Copy: 6021.546 MiB/s
6 Method: MCBLOCK Elapsed: 0.04216 MiB: 256.00000 Copy: 6071.818 MiB/s
7 Method: MCBLOCK Elapsed: 0.04288 MiB: 256.00000 Copy: 5970.288 MiB/s
8 Method: MCBLOCK Elapsed: 0.04289 MiB: 256.00000 Copy: 5968.757 MiB/s
9 Method: MCBLOCK Elapsed: 0.04272 MiB: 256.00000 Copy: 5992.790 MiB/s
AVG Method: MCBLOCK Elapsed: 0.04261 MiB: 256.00000 Copy: 6008.149 MiB/s


2GB +2GB non dual channel

hmc@hmc-P55A-UD3:~$ mbw 1024
Long uses 8 bytes. Allocating 2*134217728 elements = 2147483648 bytes of memory.
Using 262144 bytes as blocks for memcpy block copy test.
Getting down to business... Doing 10 runs per test.
0     Method: MEMCPY     Elapsed: 0.42441     MiB: 1024.00000     Copy: 2412.750 MiB/s
1     Method: MEMCPY     Elapsed: 0.42094     MiB: 1024.00000     Copy: 2432.674 MiB/s
2     Method: MEMCPY     Elapsed: 0.41692     MiB: 1024.00000     Copy: 2456.095 MiB/s
3     Method: MEMCPY     Elapsed: 0.41926     MiB: 1024.00000     Copy: 2442.410 MiB/s
4     Method: MEMCPY     Elapsed: 0.41979     MiB: 1024.00000     Copy: 2439.315 MiB/s
5     Method: MEMCPY     Elapsed: 0.41942     MiB: 1024.00000     Copy: 2441.490 MiB/s
6     Method: MEMCPY     Elapsed: 0.42052     MiB: 1024.00000     Copy: 2435.051 MiB/s
7     Method: MEMCPY     Elapsed: 0.42470     MiB: 1024.00000     Copy: 2411.085 MiB/s
8     Method: MEMCPY     Elapsed: 0.42207     MiB: 1024.00000     Copy: 2426.167 MiB/s
9     Method: MEMCPY     Elapsed: 0.42684     MiB: 1024.00000     Copy: 2398.997 MiB/s
AVG     Method: MEMCPY     Elapsed: 0.42149     MiB: 1024.00000     Copy: 2429.491 MiB/s
0     Method: DUMB     Elapsed: 0.25677     MiB: 1024.00000     Copy: 3987.958 MiB/s
1     Method: DUMB     Elapsed: 0.25691     MiB: 1024.00000     Copy: 3985.847 MiB/s
2     Method: DUMB     Elapsed: 0.25899     MiB: 1024.00000     Copy: 3953.760 MiB/s
3     Method: DUMB     Elapsed: 0.25449     MiB: 1024.00000     Copy: 4023.734 MiB/s
4     Method: DUMB     Elapsed: 0.25552     MiB: 1024.00000     Copy: 4007.483 MiB/s
5     Method: DUMB     Elapsed: 0.25518     MiB: 1024.00000     Copy: 4012.822 MiB/s
6     Method: DUMB     Elapsed: 0.25545     MiB: 1024.00000     Copy: 4008.659 MiB/s
7     Method: DUMB     Elapsed: 0.25473     MiB: 1024.00000     Copy: 4019.911 MiB/s
8     Method: DUMB     Elapsed: 0.25240     MiB: 1024.00000     Copy: 4057.052 MiB/s
9     Method: DUMB     Elapsed: 0.24977     MiB: 1024.00000     Copy: 4099.837 MiB/s
AVG     Method: DUMB     Elapsed: 0.25502     MiB: 1024.00000     Copy: 4015.348 MiB/s
0     Method: MCBLOCK     Elapsed: 0.28630     MiB: 1024.00000     Copy: 3576.730 MiB/s
1     Method: MCBLOCK     Elapsed: 0.28747     MiB: 1024.00000     Copy: 3562.061 MiB/s
2     Method: MCBLOCK     Elapsed: 0.29100     MiB: 1024.00000     Copy: 3518.961 MiB/s
3     Method: MCBLOCK     Elapsed: 0.29045     MiB: 1024.00000     Copy: 3525.576 MiB/s
4     Method: MCBLOCK     Elapsed: 0.28885     MiB: 1024.00000     Copy: 3545.080 MiB/s
5     Method: MCBLOCK     Elapsed: 0.29142     MiB: 1024.00000     Copy: 3513.877 MiB/s
6     Method: MCBLOCK     Elapsed: 0.28991     MiB: 1024.00000     Copy: 3532.192 MiB/s
7     Method: MCBLOCK     Elapsed: 0.28529     MiB: 1024.00000     Copy: 3589.330 MiB/s
8     Method: MCBLOCK     Elapsed: 0.28598     MiB: 1024.00000     Copy: 3580.607 MiB/s
9     Method: MCBLOCK     Elapsed: 0.28637     MiB: 1024.00000     Copy: 3575.794 MiB/s
AVG     Method: MCBLOCK     Elapsed: 0.28830     MiB: 1024.00000     Copy: 3551.819 MiB/s
hmc@hmc-P55A-UD3:~$ mbw 512
Long uses 8 bytes. Allocating 2*67108864 elements = 1073741824 bytes of memory.
Using 262144 bytes as blocks for memcpy block copy test.
Getting down to business... Doing 10 runs per test.
0     Method: MEMCPY     Elapsed: 0.19148     MiB: 512.00000     Copy: 2673.853 MiB/s
1     Method: MEMCPY     Elapsed: 0.18887     MiB: 512.00000     Copy: 2710.917 MiB/s
2     Method: MEMCPY     Elapsed: 0.18966     MiB: 512.00000     Copy: 2699.511 MiB/s
3     Method: MEMCPY     Elapsed: 0.18839     MiB: 512.00000     Copy: 2717.723 MiB/s
4     Method: MEMCPY     Elapsed: 0.18804     MiB: 512.00000     Copy: 2722.839 MiB/s
5     Method: MEMCPY     Elapsed: 0.18984     MiB: 512.00000     Copy: 2696.951 MiB/s
6     Method: MEMCPY     Elapsed: 0.18917     MiB: 512.00000     Copy: 2706.575 MiB/s
7     Method: MEMCPY     Elapsed: 0.18858     MiB: 512.00000     Copy: 2714.985 MiB/s
8     Method: MEMCPY     Elapsed: 0.18881     MiB: 512.00000     Copy: 2711.735 MiB/s
9     Method: MEMCPY     Elapsed: 0.18876     MiB: 512.00000     Copy: 2712.482 MiB/s
AVG     Method: MEMCPY     Elapsed: 0.18916     MiB: 512.00000     Copy: 2706.692 MiB/s
0     Method: DUMB     Elapsed: 0.11565     MiB: 512.00000     Copy: 4427.227 MiB/s
1     Method: DUMB     Elapsed: 0.11709     MiB: 512.00000     Copy: 4372.630 MiB/s
2     Method: DUMB     Elapsed: 0.11617     MiB: 512.00000     Copy: 4407.372 MiB/s
3     Method: DUMB     Elapsed: 0.11625     MiB: 512.00000     Copy: 4404.263 MiB/s
4     Method: DUMB     Elapsed: 0.11619     MiB: 512.00000     Copy: 4406.651 MiB/s
5     Method: DUMB     Elapsed: 0.11740     MiB: 512.00000     Copy: 4361.047 MiB/s
6     Method: DUMB     Elapsed: 0.11601     MiB: 512.00000     Copy: 4413.451 MiB/s
7     Method: DUMB     Elapsed: 0.11605     MiB: 512.00000     Copy: 4411.777 MiB/s
8     Method: DUMB     Elapsed: 0.11601     MiB: 512.00000     Copy: 4413.299 MiB/s
9     Method: DUMB     Elapsed: 0.11729     MiB: 512.00000     Copy: 4365.435 MiB/s
AVG     Method: DUMB     Elapsed: 0.11641     MiB: 512.00000     Copy: 4398.206 MiB/s
0     Method: MCBLOCK     Elapsed: 0.12970     MiB: 512.00000     Copy: 3947.663 MiB/s
1     Method: MCBLOCK     Elapsed: 0.13012     MiB: 512.00000     Copy: 3934.860 MiB/s
2     Method: MCBLOCK     Elapsed: 0.13027     MiB: 512.00000     Copy: 3930.419 MiB/s
3     Method: MCBLOCK     Elapsed: 0.13131     MiB: 512.00000     Copy: 3899.140 MiB/s
4     Method: MCBLOCK     Elapsed: 0.12970     MiB: 512.00000     Copy: 3947.480 MiB/s
5     Method: MCBLOCK     Elapsed: 0.12947     MiB: 512.00000     Copy: 3954.645 MiB/s
6     Method: MCBLOCK     Elapsed: 0.13021     MiB: 512.00000     Copy: 3931.959 MiB/s
7     Method: MCBLOCK     Elapsed: 0.13152     MiB: 512.00000     Copy: 3892.944 MiB/s
8     Method: MCBLOCK     Elapsed: 0.13052     MiB: 512.00000     Copy: 3922.710 MiB/s
9     Method: MCBLOCK     Elapsed: 0.13055     MiB: 512.00000     Copy: 3921.869 MiB/s
AVG     Method: MCBLOCK     Elapsed: 0.13034     MiB: 512.00000     Copy: 3928.275 MiB/s
hmc@hmc-P55A-UD3:~$ mbw 256
Long uses 8 bytes. Allocating 2*33554432 elements = 536870912 bytes of memory.
Using 262144 bytes as blocks for memcpy block copy test.
Getting down to business... Doing 10 runs per test.
0     Method: MEMCPY     Elapsed: 0.09508     MiB: 256.00000     Copy: 2692.611 MiB/s
1     Method: MEMCPY     Elapsed: 0.09609     MiB: 256.00000     Copy: 2664.086 MiB/s
2     Method: MEMCPY     Elapsed: 0.09655     MiB: 256.00000     Copy: 2651.448 MiB/s
3     Method: MEMCPY     Elapsed: 0.09687     MiB: 256.00000     Copy: 2642.635 MiB/s
4     Method: MEMCPY     Elapsed: 0.09707     MiB: 256.00000     Copy: 2637.163 MiB/s
5     Method: MEMCPY     Elapsed: 0.11169     MiB: 256.00000     Copy: 2292.099 MiB/s
6     Method: MEMCPY     Elapsed: 0.11025     MiB: 256.00000     Copy: 2322.038 MiB/s
7     Method: MEMCPY     Elapsed: 0.11284     MiB: 256.00000     Copy: 2268.619 MiB/s
8     Method: MEMCPY     Elapsed: 0.10727     MiB: 256.00000     Copy: 2386.568 MiB/s
9     Method: MEMCPY     Elapsed: 0.10817     MiB: 256.00000     Copy: 2366.667 MiB/s
AVG     Method: MEMCPY     Elapsed: 0.10319     MiB: 256.00000     Copy: 2480.904 MiB/s
0     Method: DUMB     Elapsed: 0.06330     MiB: 256.00000     Copy: 4044.298 MiB/s
1     Method: DUMB     Elapsed: 0.06149     MiB: 256.00000     Copy: 4163.482 MiB/s
2     Method: DUMB     Elapsed: 0.06126     MiB: 256.00000     Copy: 4178.978 MiB/s
3     Method: DUMB     Elapsed: 0.06130     MiB: 256.00000     Copy: 4176.046 MiB/s
4     Method: DUMB     Elapsed: 0.06057     MiB: 256.00000     Copy: 4226.515 MiB/s
5     Method: DUMB     Elapsed: 0.05994     MiB: 256.00000     Copy: 4271.009 MiB/s
6     Method: DUMB     Elapsed: 0.06348     MiB: 256.00000     Copy: 4032.703 MiB/s
7     Method: DUMB     Elapsed: 0.06033     MiB: 256.00000     Copy: 4243.117 MiB/s
8     Method: DUMB     Elapsed: 0.06389     MiB: 256.00000     Copy: 4006.761 MiB/s
9     Method: DUMB     Elapsed: 0.06376     MiB: 256.00000     Copy: 4015.371 MiB/s
AVG     Method: DUMB     Elapsed: 0.06193     MiB: 256.00000     Copy: 4133.586 MiB/s
0     Method: MCBLOCK     Elapsed: 0.07098     MiB: 256.00000     Copy: 3606.701 MiB/s
1     Method: MCBLOCK     Elapsed: 0.07154     MiB: 256.00000     Copy: 3578.468 MiB/s
2     Method: MCBLOCK     Elapsed: 0.07568     MiB: 256.00000     Copy: 3382.709 MiB/s
3     Method: MCBLOCK     Elapsed: 0.07848     MiB: 256.00000     Copy: 3261.894 MiB/s
4     Method: MCBLOCK     Elapsed: 0.07390     MiB: 256.00000     Copy: 3463.906 MiB/s
5     Method: MCBLOCK     Elapsed: 0.07406     MiB: 256.00000     Copy: 3456.657 MiB/s
6     Method: MCBLOCK     Elapsed: 0.07167     MiB: 256.00000     Copy: 3572.176 MiB/s
7     Method: MCBLOCK     Elapsed: 0.07113     MiB: 256.00000     Copy: 3599.095 MiB/s
8     Method: MCBLOCK     Elapsed: 0.07047     MiB: 256.00000     Copy: 3632.545 MiB/s
9     Method: MCBLOCK     Elapsed: 0.07082     MiB: 256.00000     Copy: 3614.747 MiB/s
AVG     Method: MCBLOCK     Elapsed: 0.07287     MiB: 256.00000     Copy: 3512.946 MiB/s

6GB = 2GB +2GB (dual channel) + 2GB (STANDALONE)

hmc@hmc-P55A-UD3:~$ mbw 1024
Long uses 8 bytes. Allocating 2*134217728 elements = 2147483648 bytes of memory.
Using 262144 bytes as blocks for memcpy block copy test.
Getting down to business... Doing 10 runs per test.
0     Method: MEMCPY     Elapsed: 0.27084     MiB: 1024.00000     Copy: 3780.886 MiB/s
1     Method: MEMCPY     Elapsed: 0.26853     MiB: 1024.00000     Copy: 3813.340 MiB/s
2     Method: MEMCPY     Elapsed: 0.26685     MiB: 1024.00000     Copy: 3837.304 MiB/s
3     Method: MEMCPY     Elapsed: 0.26641     MiB: 1024.00000     Copy: 3843.642 MiB/s
4     Method: MEMCPY     Elapsed: 0.27048     MiB: 1024.00000     Copy: 3785.834 MiB/s
5     Method: MEMCPY     Elapsed: 0.26700     MiB: 1024.00000     Copy: 3835.134 MiB/s
6     Method: MEMCPY     Elapsed: 0.27118     MiB: 1024.00000     Copy: 3776.104 MiB/s
7     Method: MEMCPY     Elapsed: 0.27515     MiB: 1024.00000     Copy: 3721.606 MiB/s
8     Method: MEMCPY     Elapsed: 0.27256     MiB: 1024.00000     Copy: 3756.957 MiB/s
9     Method: MEMCPY     Elapsed: 0.26711     MiB: 1024.00000     Copy: 3833.584 MiB/s
AVG     Method: MEMCPY     Elapsed: 0.26961     MiB: 1024.00000     Copy: 3798.043 MiB/s
0     Method: DUMB     Elapsed: 0.16116     MiB: 1024.00000     Copy: 6354.092 MiB/s
1     Method: DUMB     Elapsed: 0.16050     MiB: 1024.00000     Copy: 6379.943 MiB/s
2     Method: DUMB     Elapsed: 0.16118     MiB: 1024.00000     Copy: 6353.224 MiB/s
3     Method: DUMB     Elapsed: 0.16137     MiB: 1024.00000     Copy: 6345.862 MiB/s
4     Method: DUMB     Elapsed: 0.16034     MiB: 1024.00000     Copy: 6386.628 MiB/s
5     Method: DUMB     Elapsed: 0.16053     MiB: 1024.00000     Copy: 6378.830 MiB/s
6     Method: DUMB     Elapsed: 0.16184     MiB: 1024.00000     Copy: 6327.198 MiB/s
7     Method: DUMB     Elapsed: 0.16127     MiB: 1024.00000     Copy: 6349.679 MiB/s
8     Method: DUMB     Elapsed: 0.16116     MiB: 1024.00000     Copy: 6354.052 MiB/s
9     Method: DUMB     Elapsed: 0.16107     MiB: 1024.00000     Copy: 6357.682 MiB/s
AVG     Method: DUMB     Elapsed: 0.16104     MiB: 1024.00000     Copy: 6358.673 MiB/s
0     Method: MCBLOCK     Elapsed: 0.18362     MiB: 1024.00000     Copy: 5576.735 MiB/s
1     Method: MCBLOCK     Elapsed: 0.18377     MiB: 1024.00000     Copy: 5572.213 MiB/s
2     Method: MCBLOCK     Elapsed: 0.18396     MiB: 1024.00000     Copy: 5566.427 MiB/s
3     Method: MCBLOCK     Elapsed: 0.18418     MiB: 1024.00000     Copy: 5559.778 MiB/s
4     Method: MCBLOCK     Elapsed: 0.18490     MiB: 1024.00000     Copy: 5538.219 MiB/s
5     Method: MCBLOCK     Elapsed: 0.18587     MiB: 1024.00000     Copy: 5509.108 MiB/s
6     Method: MCBLOCK     Elapsed: 0.18397     MiB: 1024.00000     Copy: 5566.034 MiB/s
7     Method: MCBLOCK     Elapsed: 0.18440     MiB: 1024.00000     Copy: 5553.085 MiB/s
8     Method: MCBLOCK     Elapsed: 0.18420     MiB: 1024.00000     Copy: 5559.175 MiB/s
9     Method: MCBLOCK     Elapsed: 0.18551     MiB: 1024.00000     Copy: 5519.978 MiB/s
AVG     Method: MCBLOCK     Elapsed: 0.18444     MiB: 1024.00000     Copy: 5551.992 MiB/s
hmc@hmc-P55A-UD3:~$ mbw 512
Long uses 8 bytes. Allocating 2*67108864 elements = 1073741824 bytes of memory.
Using 262144 bytes as blocks for memcpy block copy test.
Getting down to business... Doing 10 runs per test.
0     Method: MEMCPY     Elapsed: 0.13962     MiB: 512.00000     Copy: 3667.070 MiB/s
1     Method: MEMCPY     Elapsed: 0.13900     MiB: 512.00000     Copy: 3683.533 MiB/s
2     Method: MEMCPY     Elapsed: 0.13892     MiB: 512.00000     Copy: 3685.627 MiB/s
3     Method: MEMCPY     Elapsed: 0.13958     MiB: 512.00000     Copy: 3668.121 MiB/s
4     Method: MEMCPY     Elapsed: 0.13903     MiB: 512.00000     Copy: 3682.605 MiB/s
5     Method: MEMCPY     Elapsed: 0.14128     MiB: 512.00000     Copy: 3623.983 MiB/s
6     Method: MEMCPY     Elapsed: 0.14006     MiB: 512.00000     Copy: 3655.628 MiB/s
7     Method: MEMCPY     Elapsed: 0.14008     MiB: 512.00000     Copy: 3655.002 MiB/s
8     Method: MEMCPY     Elapsed: 0.13891     MiB: 512.00000     Copy: 3685.760 MiB/s
9     Method: MEMCPY     Elapsed: 0.13932     MiB: 512.00000     Copy: 3674.993 MiB/s
AVG     Method: MEMCPY     Elapsed: 0.13958     MiB: 512.00000     Copy: 3668.139 MiB/s
0     Method: DUMB     Elapsed: 0.08039     MiB: 512.00000     Copy: 6369.031 MiB/s
1     Method: DUMB     Elapsed: 0.08131     MiB: 512.00000     Copy: 6296.501 MiB/s
2     Method: DUMB     Elapsed: 0.08040     MiB: 512.00000     Copy: 6368.159 MiB/s
3     Method: DUMB     Elapsed: 0.08054     MiB: 512.00000     Copy: 6357.326 MiB/s
4     Method: DUMB     Elapsed: 0.08120     MiB: 512.00000     Copy: 6305.263 MiB/s
5     Method: DUMB     Elapsed: 0.08048     MiB: 512.00000     Copy: 6362.145 MiB/s
6     Method: DUMB     Elapsed: 0.08099     MiB: 512.00000     Copy: 6321.846 MiB/s
7     Method: DUMB     Elapsed: 0.08118     MiB: 512.00000     Copy: 6307.050 MiB/s
8     Method: DUMB     Elapsed: 0.08055     MiB: 512.00000     Copy: 6356.064 MiB/s
9     Method: DUMB     Elapsed: 0.08066     MiB: 512.00000     Copy: 6347.632 MiB/s
AVG     Method: DUMB     Elapsed: 0.08077     MiB: 512.00000     Copy: 6338.987 MiB/s
0     Method: MCBLOCK     Elapsed: 0.09177     MiB: 512.00000     Copy: 5579.226 MiB/s
1     Method: MCBLOCK     Elapsed: 0.09209     MiB: 512.00000     Copy: 5560.080 MiB/s
2     Method: MCBLOCK     Elapsed: 0.09215     MiB: 512.00000     Copy: 5556.400 MiB/s
3     Method: MCBLOCK     Elapsed: 0.09302     MiB: 512.00000     Copy: 5504.429 MiB/s
4     Method: MCBLOCK     Elapsed: 0.09206     MiB: 512.00000     Copy: 5561.409 MiB/s
5     Method: MCBLOCK     Elapsed: 0.09246     MiB: 512.00000     Copy: 5537.470 MiB/s
6     Method: MCBLOCK     Elapsed: 0.09254     MiB: 512.00000     Copy: 5532.503 MiB/s
7     Method: MCBLOCK     Elapsed: 0.09258     MiB: 512.00000     Copy: 5530.292 MiB/s
8     Method: MCBLOCK     Elapsed: 0.09275     MiB: 512.00000     Copy: 5520.037 MiB/s
9     Method: MCBLOCK     Elapsed: 0.09251     MiB: 512.00000     Copy: 5534.477 MiB/s
AVG     Method: MCBLOCK     Elapsed: 0.09239     MiB: 512.00000     Copy: 5541.551 MiB/s
hmc@hmc-P55A-UD3:~$ mbw 256
Long uses 8 bytes. Allocating 2*33554432 elements = 536870912 bytes of memory.
Using 262144 bytes as blocks for memcpy block copy test.
Getting down to business... Doing 10 runs per test.
0     Method: MEMCPY     Elapsed: 0.07053     MiB: 256.00000     Copy: 3629.713 MiB/s
1     Method: MEMCPY     Elapsed: 0.07003     MiB: 256.00000     Copy: 3655.733 MiB/s
2     Method: MEMCPY     Elapsed: 0.07104     MiB: 256.00000     Copy: 3603.807 MiB/s
3     Method: MEMCPY     Elapsed: 0.07064     MiB: 256.00000     Copy: 3624.163 MiB/s
4     Method: MEMCPY     Elapsed: 0.06991     MiB: 256.00000     Copy: 3661.694 MiB/s
5     Method: MEMCPY     Elapsed: 0.07098     MiB: 256.00000     Copy: 3606.701 MiB/s
6     Method: MEMCPY     Elapsed: 0.07023     MiB: 256.00000     Copy: 3644.958 MiB/s
7     Method: MEMCPY     Elapsed: 0.07012     MiB: 256.00000     Copy: 3650.832 MiB/s
8     Method: MEMCPY     Elapsed: 0.06997     MiB: 256.00000     Copy: 3658.815 MiB/s
9     Method: MEMCPY     Elapsed: 0.07008     MiB: 256.00000     Copy: 3653.020 MiB/s
AVG     Method: MEMCPY     Elapsed: 0.07035     MiB: 256.00000     Copy: 3638.829 MiB/s
0     Method: DUMB     Elapsed: 0.03986     MiB: 256.00000     Copy: 6422.156 MiB/s
1     Method: DUMB     Elapsed: 0.03988     MiB: 256.00000     Copy: 6419.902 MiB/s
2     Method: DUMB     Elapsed: 0.03997     MiB: 256.00000     Copy: 6405.124 MiB/s
3     Method: DUMB     Elapsed: 0.03986     MiB: 256.00000     Copy: 6422.801 MiB/s
4     Method: DUMB     Elapsed: 0.04007     MiB: 256.00000     Copy: 6388.979 MiB/s
5     Method: DUMB     Elapsed: 0.03980     MiB: 256.00000     Copy: 6431.676 MiB/s
6     Method: DUMB     Elapsed: 0.04020     MiB: 256.00000     Copy: 6368.793 MiB/s
7     Method: DUMB     Elapsed: 0.04051     MiB: 256.00000     Copy: 6319.115 MiB/s
8     Method: DUMB     Elapsed: 0.04023     MiB: 256.00000     Copy: 6362.620 MiB/s
9     Method: DUMB     Elapsed: 0.04010     MiB: 256.00000     Copy: 6384.677 MiB/s
AVG     Method: DUMB     Elapsed: 0.04005     MiB: 256.00000     Copy: 6392.409 MiB/s
0     Method: MCBLOCK     Elapsed: 0.04671     MiB: 256.00000     Copy: 5480.273 MiB/s
1     Method: MCBLOCK     Elapsed: 0.04701     MiB: 256.00000     Copy: 5445.302 MiB/s
2     Method: MCBLOCK     Elapsed: 0.04679     MiB: 256.00000     Copy: 5471.488 MiB/s
3     Method: MCBLOCK     Elapsed: 0.04615     MiB: 256.00000     Copy: 5547.490 MiB/s
4     Method: MCBLOCK     Elapsed: 0.04636     MiB: 256.00000     Copy: 5521.644 MiB/s
5     Method: MCBLOCK     Elapsed: 0.04634     MiB: 256.00000     Copy: 5524.862 MiB/s
6     Method: MCBLOCK     Elapsed: 0.04680     MiB: 256.00000     Copy: 5470.202 MiB/s
7     Method: MCBLOCK     Elapsed: 0.04626     MiB: 256.00000     Copy: 5533.460 MiB/s
8     Method: MCBLOCK     Elapsed: 0.04653     MiB: 256.00000     Copy: 5501.590 MiB/s
9     Method: MCBLOCK     Elapsed: 0.04636     MiB: 256.00000     Copy: 5522.002 MiB/s
AVG     Method: MCBLOCK     Elapsed: 0.04653     MiB: 256.00000     Copy: 5501.649 MiB/s


Finally I got one to one exchanged after I send the Kingston memory for service.

8GB=2GB+2GB+2GB+2GB 2x DUAL CHANNEL

hmc@hmc-P55A-UD3:~/.mozilla/plugins$ mbw 1024
Long uses 8 bytes. Allocating 2*134217728 elements = 2147483648 bytes of memory.
Using 262144 bytes as blocks for memcpy block copy test.
Getting down to business... Doing 10 runs per test.
0    Method: MEMCPY    Elapsed: 0.27377    MiB: 1024.00000    Copy: 3740.366 MiB/s
1    Method: MEMCPY    Elapsed: 0.27325    MiB: 1024.00000    Copy: 3747.525 MiB/s
2    Method: MEMCPY    Elapsed: 0.27273    MiB: 1024.00000    Copy: 3754.588 MiB/s
3    Method: MEMCPY    Elapsed: 0.27165    MiB: 1024.00000    Copy: 3769.626 MiB/s
4    Method: MEMCPY    Elapsed: 0.27144    MiB: 1024.00000    Copy: 3772.417 MiB/s
5    Method: MEMCPY    Elapsed: 0.27104    MiB: 1024.00000    Copy: 3778.096 MiB/s
6    Method: MEMCPY    Elapsed: 0.27625    MiB: 1024.00000    Copy: 3706.760 MiB/s
7    Method: MEMCPY    Elapsed: 0.27174    MiB: 1024.00000    Copy: 3768.280 MiB/s
8    Method: MEMCPY    Elapsed: 0.27318    MiB: 1024.00000    Copy: 3748.485 MiB/s
9    Method: MEMCPY    Elapsed: 0.27101    MiB: 1024.00000    Copy: 3778.486 MiB/s
AVG    Method: MEMCPY    Elapsed: 0.27261    MiB: 1024.00000    Copy: 3756.345 MiB/s
0    Method: DUMB    Elapsed: 0.16348    MiB: 1024.00000    Copy: 6263.725 MiB/s
1    Method: DUMB    Elapsed: 0.16312    MiB: 1024.00000    Copy: 6277.779 MiB/s
2    Method: DUMB    Elapsed: 0.16424    MiB: 1024.00000    Copy: 6234.892 MiB/s
3    Method: DUMB    Elapsed: 0.16255    MiB: 1024.00000    Copy: 6299.716 MiB/s
4    Method: DUMB    Elapsed: 0.16270    MiB: 1024.00000    Copy: 6293.599 MiB/s
5    Method: DUMB    Elapsed: 0.16331    MiB: 1024.00000    Copy: 6270.284 MiB/s
6    Method: DUMB    Elapsed: 0.16300    MiB: 1024.00000    Copy: 6282.170 MiB/s
7    Method: DUMB    Elapsed: 0.16328    MiB: 1024.00000    Copy: 6271.397 MiB/s
8    Method: DUMB    Elapsed: 0.16315    MiB: 1024.00000    Copy: 6276.240 MiB/s
9    Method: DUMB    Elapsed: 0.16307    MiB: 1024.00000    Copy: 6279.666 MiB/s
AVG    Method: DUMB    Elapsed: 0.16319    MiB: 1024.00000    Copy: 6274.902 MiB/s
0    Method: MCBLOCK    Elapsed: 0.19477    MiB: 1024.00000    Copy: 5257.375 MiB/s
1    Method: MCBLOCK    Elapsed: 0.19399    MiB: 1024.00000    Copy: 5278.623 MiB/s
2    Method: MCBLOCK    Elapsed: 0.19529    MiB: 1024.00000    Copy: 5243.404 MiB/s
3    Method: MCBLOCK    Elapsed: 0.19587    MiB: 1024.00000    Copy: 5228.064 MiB/s
4    Method: MCBLOCK    Elapsed: 0.19450    MiB: 1024.00000    Copy: 5264.781 MiB/s
5    Method: MCBLOCK    Elapsed: 0.19498    MiB: 1024.00000    Copy: 5251.767 MiB/s
6    Method: MCBLOCK    Elapsed: 0.19489    MiB: 1024.00000    Copy: 5254.219 MiB/s
7    Method: MCBLOCK    Elapsed: 0.19470    MiB: 1024.00000    Copy: 5259.238 MiB/s
8    Method: MCBLOCK    Elapsed: 0.19503    MiB: 1024.00000    Copy: 5250.367 MiB/s
9    Method: MCBLOCK    Elapsed: 0.19473    MiB: 1024.00000    Copy: 5258.617 MiB/s
AVG    Method: MCBLOCK    Elapsed: 0.19488    MiB: 1024.00000    Copy: 5254.615 MiB/s
hmc@hmc-P55A-UD3:~/.mozilla/plugins$ mbw 512
Long uses 8 bytes. Allocating 2*67108864 elements = 1073741824 bytes of memory.
Using 262144 bytes as blocks for memcpy block copy test.
Getting down to business... Doing 10 runs per test.
0    Method: MEMCPY    Elapsed: 0.13452    MiB: 512.00000    Copy: 3806.210 MiB/s
1    Method: MEMCPY    Elapsed: 0.13578    MiB: 512.00000    Copy: 3770.806 MiB/s
2    Method: MEMCPY    Elapsed: 0.13605    MiB: 512.00000    Copy: 3763.350 MiB/s
3    Method: MEMCPY    Elapsed: 0.13528    MiB: 512.00000    Copy: 3784.687 MiB/s
4    Method: MEMCPY    Elapsed: 0.13592    MiB: 512.00000    Copy: 3766.839 MiB/s
5    Method: MEMCPY    Elapsed: 0.13602    MiB: 512.00000    Copy: 3764.235 MiB/s
6    Method: MEMCPY    Elapsed: 0.13369    MiB: 512.00000    Copy: 3829.669 MiB/s
7    Method: MEMCPY    Elapsed: 0.13598    MiB: 512.00000    Copy: 3765.121 MiB/s
8    Method: MEMCPY    Elapsed: 0.13901    MiB: 512.00000    Copy: 3683.215 MiB/s
9    Method: MEMCPY    Elapsed: 0.13823    MiB: 512.00000    Copy: 3703.891 MiB/s
AVG    Method: MEMCPY    Elapsed: 0.13605    MiB: 512.00000    Copy: 3763.356 MiB/s
0    Method: DUMB    Elapsed: 0.07980    MiB: 512.00000    Copy: 6415.719 MiB/s
1    Method: DUMB    Elapsed: 0.08045    MiB: 512.00000    Copy: 6364.439 MiB/s
2    Method: DUMB    Elapsed: 0.07975    MiB: 512.00000    Copy: 6420.385 MiB/s
3    Method: DUMB    Elapsed: 0.07991    MiB: 512.00000    Copy: 6407.529 MiB/s
4    Method: DUMB    Elapsed: 0.07915    MiB: 512.00000    Copy: 6469.057 MiB/s
5    Method: DUMB    Elapsed: 0.07941    MiB: 512.00000    Copy: 6447.145 MiB/s
6    Method: DUMB    Elapsed: 0.07919    MiB: 512.00000    Copy: 6465.544 MiB/s
7    Method: DUMB    Elapsed: 0.08044    MiB: 512.00000    Copy: 6364.676 MiB/s
8    Method: DUMB    Elapsed: 0.07933    MiB: 512.00000    Copy: 6453.809 MiB/s
9    Method: DUMB    Elapsed: 0.07942    MiB: 512.00000    Copy: 6447.064 MiB/s
AVG    Method: DUMB    Elapsed: 0.07968    MiB: 512.00000    Copy: 6425.332 MiB/s
0    Method: MCBLOCK    Elapsed: 0.09705    MiB: 512.00000    Copy: 5275.685 MiB/s
1    Method: MCBLOCK    Elapsed: 0.09741    MiB: 512.00000    Copy: 5255.972 MiB/s
2    Method: MCBLOCK    Elapsed: 0.09755    MiB: 512.00000    Copy: 5248.806 MiB/s
3    Method: MCBLOCK    Elapsed: 0.09784    MiB: 512.00000    Copy: 5233.247 MiB/s
4    Method: MCBLOCK    Elapsed: 0.09781    MiB: 512.00000    Copy: 5234.853 MiB/s
5    Method: MCBLOCK    Elapsed: 0.09760    MiB: 512.00000    Copy: 5245.633 MiB/s
6    Method: MCBLOCK    Elapsed: 0.09735    MiB: 512.00000    Copy: 5259.481 MiB/s
7    Method: MCBLOCK    Elapsed: 0.09764    MiB: 512.00000    Copy: 5243.591 MiB/s
8    Method: MCBLOCK    Elapsed: 0.09764    MiB: 512.00000    Copy: 5243.591 MiB/s
9    Method: MCBLOCK    Elapsed: 0.09803    MiB: 512.00000    Copy: 5223.051 MiB/s
AVG    Method: MCBLOCK    Elapsed: 0.09759    MiB: 512.00000    Copy: 5246.353 MiB/s
hmc@hmc-P55A-UD3:~/.mozilla/plugins$ mbw 256
Long uses 8 bytes. Allocating 2*33554432 elements = 536870912 bytes of memory.
Using 262144 bytes as blocks for memcpy block copy test.
Getting down to business... Doing 10 runs per test.
0    Method: MEMCPY    Elapsed: 0.06656    MiB: 256.00000    Copy: 3846.443 MiB/s
1    Method: MEMCPY    Elapsed: 0.06772    MiB: 256.00000    Copy: 3780.439 MiB/s
2    Method: MEMCPY    Elapsed: 0.06691    MiB: 256.00000    Copy: 3825.806 MiB/s
3    Method: MEMCPY    Elapsed: 0.06685    MiB: 256.00000    Copy: 3829.240 MiB/s
4    Method: MEMCPY    Elapsed: 0.06660    MiB: 256.00000    Copy: 3843.613 MiB/s
5    Method: MEMCPY    Elapsed: 0.06633    MiB: 256.00000    Copy: 3859.549 MiB/s
6    Method: MEMCPY    Elapsed: 0.06631    MiB: 256.00000    Copy: 3860.946 MiB/s
7    Method: MEMCPY    Elapsed: 0.06636    MiB: 256.00000    Copy: 3857.920 MiB/s
8    Method: MEMCPY    Elapsed: 0.06916    MiB: 256.00000    Copy: 3701.776 MiB/s
9    Method: MEMCPY    Elapsed: 0.06583    MiB: 256.00000    Copy: 3888.864 MiB/s
AVG    Method: MEMCPY    Elapsed: 0.06686    MiB: 256.00000    Copy: 3828.782 MiB/s
0    Method: DUMB    Elapsed: 0.04020    MiB: 256.00000    Copy: 6367.684 MiB/s
1    Method: DUMB    Elapsed: 0.03981    MiB: 256.00000    Copy: 6431.030 MiB/s
2    Method: DUMB    Elapsed: 0.04032    MiB: 256.00000    Copy: 6349.679 MiB/s
3    Method: DUMB    Elapsed: 0.04047    MiB: 256.00000    Copy: 6325.361 MiB/s
4    Method: DUMB    Elapsed: 0.04054    MiB: 256.00000    Copy: 6315.374 MiB/s
5    Method: DUMB    Elapsed: 0.04039    MiB: 256.00000    Copy: 6337.732 MiB/s
6    Method: DUMB    Elapsed: 0.03991    MiB: 256.00000    Copy: 6415.075 MiB/s
7    Method: DUMB    Elapsed: 0.04110    MiB: 256.00000    Copy: 6228.710 MiB/s
8    Method: DUMB    Elapsed: 0.03991    MiB: 256.00000    Copy: 6413.950 MiB/s
9    Method: DUMB    Elapsed: 0.04009    MiB: 256.00000    Copy: 6384.995 MiB/s
AVG    Method: DUMB    Elapsed: 0.04027    MiB: 256.00000    Copy: 6356.442 MiB/s
0    Method: MCBLOCK    Elapsed: 0.04697    MiB: 256.00000    Copy: 5450.752 MiB/s
1    Method: MCBLOCK    Elapsed: 0.04661    MiB: 256.00000    Copy: 5492.501 MiB/s
2    Method: MCBLOCK    Elapsed: 0.04729    MiB: 256.00000    Copy: 5413.063 MiB/s
3    Method: MCBLOCK    Elapsed: 0.04693    MiB: 256.00000    Copy: 5455.165 MiB/s
4    Method: MCBLOCK    Elapsed: 0.04758    MiB: 256.00000    Copy: 5380.073 MiB/s
5    Method: MCBLOCK    Elapsed: 0.04689    MiB: 256.00000    Copy: 5460.052 MiB/s
6    Method: MCBLOCK    Elapsed: 0.04754    MiB: 256.00000    Copy: 5385.052 MiB/s
7    Method: MCBLOCK    Elapsed: 0.04731    MiB: 256.00000    Copy: 5410.889 MiB/s
8    Method: MCBLOCK    Elapsed: 0.04789    MiB: 256.00000    Copy: 5345.137 MiB/s
9    Method: MCBLOCK    Elapsed: 0.04723    MiB: 256.00000    Copy: 5420.628 MiB/s
AVG    Method: MCBLOCK    Elapsed: 0.04722    MiB: 256.00000    Copy: 5421.007 MiB/s


Conclusion

Comparing the 2GB+2GB , DUAL channel and non-dual  channel configurations,  we can it is about 50% faster for using dual channel setup.

Friday, April 04, 2014

My understanding of Async I/O setting for Oracle Database on AIX platform

The following diagram is based on my understanding of page 54, 55 and 66 of document Oracle Architecture and Tuning on AIX (v 2.20).pdf


Thursday, April 03, 2014

can not allocate 100% raw partition to oracle data file

My db creation failed shown below due to specify exact 100% size of raw partition to Oracle data file.

Maybe some overhead needed, but what is the size needed ?

initially



-bash-3.2$ cat cre_db.sql
STARTUP NOMOUNT
CREATE DATABASE "RAWDB1"
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
DATAFILE '/software/oracle/admin/RAWDB1/conf/RAWDB1_system_raw_1000m' size 900m reuse
sysaux datafile '/software/oracle/admin/RAWDB1/conf/RAWDB1_sysaux_raw_600m'size 600m  reuse
undo tablespace "UNDOTBS1" datafile '/software/oracle/admin/RAWDB1/conf/RAWDB1_undotbs1_raw_500m' size 480m reuse
default temporary tablespace temp tempfile '/software/oracle/admin/RAWDB1/conf/RAWDB1_temp_raw_250m' size 200m reuse
LOGFILE
  GROUP 1 ('/software/oracle/admin/RAWDB1/conf/RAWDB1_redo1_1_raw_120m')  SIZE 50M reuse ,
  GROUP 2 ('/software/oracle/admin/RAWDB1/conf/RAWDB1_redo1_2_raw_120m')  SIZE 50M reuse
user sys identified by "oracle123" user  system identified by "oracle123" ;
-bash-3.2$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Thu Apr 3 16:42:51 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

16:42:51 SYS@RAWDB1> set echo on
16:42:54 SYS@RAWDB1> @cre_db
16:42:56 SYS@RAWDB1> STARTUP NOMOUNT
ORACLE instance started.

Total System Global Area  901775360 bytes
Fixed Size                  2100424 bytes
Variable Size             226493240 bytes
Database Buffers          666894336 bytes
Redo Buffers                6287360 bytes
16:42:57 SYS@RAWDB1> CREATE DATABASE "RAWDB1"
16:42:57   2      MAXLOGFILES 16
16:42:57   3      MAXLOGMEMBERS 3
16:42:57   4      MAXDATAFILES 100
16:42:57   5      MAXINSTANCES 8
16:42:57   6      MAXLOGHISTORY 292
16:42:57   7  DATAFILE '/software/oracle/admin/RAWDB1/conf/RAWDB1_system_raw_1000m' size 900m reuse
16:42:57   8  sysaux datafile '/software/oracle/admin/RAWDB1/conf/RAWDB1_sysaux_raw_600m'size 600m  reuse
16:42:57   9  undo tablespace "UNDOTBS1" datafile '/software/oracle/admin/RAWDB1/conf/RAWDB1_undotbs1_raw_500m' size 480m reuse
16:42:57  10  default temporary tablespace temp tempfile '/software/oracle/admin/RAWDB1/conf/RAWDB1_temp_raw_250m' size 200m reuse
16:42:57  11  LOGFILE
16:42:57  12    GROUP 1 ('/software/oracle/admin/RAWDB1/conf/RAWDB1_redo1_1_raw_120m')  SIZE 50M reuse ,
16:42:57  13    GROUP 2 ('/software/oracle/admin/RAWDB1/conf/RAWDB1_redo1_2_raw_120m')  SIZE 50M reuse
16:42:57  14  user sys identified by "oracle123" user  system identified by "oracle123" ;
CREATE DATABASE "RAWDB1"
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

Thu Apr 03 16:38:00 SGT 2014
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE  '/software/oracle/admin/RAWDB1/conf/RAWDB1_undotbs1_raw_500m' size 500m reuse

ORA-1119 signalled during: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE  '/software/oracle/admin/RAWDB1/conf/RAWDB1_undotbs1_raw_500m' size 500m reuse
...
Thu Apr 03 16:38:00 SGT 2014
Errors in file /software/oracle/admin/RAWDB1/udump/rawdb1_ora_24331.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01119: error in creating database file '/software/oracle/admin/RAWDB1/conf/RAWDB1_undotbs1_raw_500m'
ORA-27042: not enough space on raw partition to fullfill request
Additional information: 3
Thu Apr 03 16:38:00 SGT 2014
Errors in file /software/oracle/admin/RAWDB1/udump/rawdb1_ora_24331.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5799
ORA-00604: error occurred at recursive SQL level 1
ORA-01119: error in creating database file '/software/oracle/admin/RAWDB1/conf/RAWDB1_undotbs1_raw_500m'
ORA-27042: not enough space on raw partition to fullfill request
Additional information: 3
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 24331
ORA-1092 signalled during: CREATE DATABASE "RAWDB1"
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
DATAFILE '/software/oracle/admin/RAWDB1/conf/RAWDB1_system_raw_1000m' size 900m reuse
sysaux datafile '/software/oracle/admin/RAWDB1/conf/RAWDB1_sysaux_raw_600m'size 600m  reuse
undo tablespace "UNDOTBS1" datafile '/software/oracle/admin/RAWDB1/conf/RAWDB1_undotbs1_raw_500m' size 500m reuse
default temporary tablespace temp tempfile '/software/oracle/admin/RAWDB1/conf/RAWDB1_temp_raw_250m' size 200m reuse
LOGFILE
  GROUP 1 ('/software/oracle/admin/RAWDB1/conf/RAWDB1_redo1_1_raw_120m')  SIZE 50M reuse ,
  GROUP 2 ('/software/oracle/admin/RAWDB1/conf/RAWDB1_redo1_2_raw_120m')  SIZE 50M reuse
user sys identified by *user  system identified by *...





Revise data file size and re-create


-bash-3.2$ cat cre_db.sql
STARTUP NOMOUNT
CREATE DATABASE "RAWDB1"
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
DATAFILE '/software/oracle/admin/RAWDB1/conf/RAWDB1_system_raw_1000m' size 900m reuse
sysaux datafile '/software/oracle/admin/RAWDB1/conf/RAWDB1_sysaux_raw_600m'size 560m  reuse
undo tablespace "UNDOTBS1" datafile '/software/oracle/admin/RAWDB1/conf/RAWDB1_undotbs1_raw_500m' size 480m reuse
default temporary tablespace temp tempfile '/software/oracle/admin/RAWDB1/conf/RAWDB1_temp_raw_250m' size 200m reuse
LOGFILE
  GROUP 1 ('/software/oracle/admin/RAWDB1/conf/RAWDB1_redo1_1_raw_120m')  SIZE 50M reuse ,
  GROUP 2 ('/software/oracle/admin/RAWDB1/conf/RAWDB1_redo1_2_raw_120m')  SIZE 50M reuse
user sys identified by "oracle123" user  system identified by "oracle123" ;
-bash-3.2$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Thu Apr 3 16:44:33 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

16:44:33 SYS@RAWDB1>
SP2-0042: unknown command "" - rest of line ignored.
16:44:35 SYS@RAWDB1>
16:44:35 SYS@RAWDB1> set echo on
16:44:38 SYS@RAWDB1> @cre_db
16:44:41 SYS@RAWDB1> STARTUP NOMOUNT
ORACLE instance started.

Total System Global Area  901775360 bytes
Fixed Size                  2100424 bytes
Variable Size             226493240 bytes
Database Buffers          666894336 bytes
Redo Buffers                6287360 bytes
16:44:41 SYS@RAWDB1> CREATE DATABASE "RAWDB1"
16:44:41   2      MAXLOGFILES 16
16:44:41   3      MAXLOGMEMBERS 3
16:44:41   4      MAXDATAFILES 100
16:44:41   5      MAXINSTANCES 8
16:44:41   6      MAXLOGHISTORY 292
16:44:41   7  DATAFILE '/software/oracle/admin/RAWDB1/conf/RAWDB1_system_raw_1000m' size 900m reuse
16:44:41   8  sysaux datafile '/software/oracle/admin/RAWDB1/conf/RAWDB1_sysaux_raw_600m'size 560m  reuse
16:44:41   9  undo tablespace "UNDOTBS1" datafile '/software/oracle/admin/RAWDB1/conf/RAWDB1_undotbs1_raw_500m' size 480m reuse
16:44:41  10  default temporary tablespace temp tempfile '/software/oracle/admin/RAWDB1/conf/RAWDB1_temp_raw_250m' size 200m reuse
16:44:41  11  LOGFILE
16:44:41  12    GROUP 1 ('/software/oracle/admin/RAWDB1/conf/RAWDB1_redo1_1_raw_120m')  SIZE 50M reuse ,
16:44:41  13    GROUP 2 ('/software/oracle/admin/RAWDB1/conf/RAWDB1_redo1_2_raw_120m')  SIZE 50M reuse
16:44:41  14  user sys identified by "oracle123" user  system identified by "oracle123" ;

Database created.

Elapsed: 00:00:13.63