客户系统部署了Oracle Linux 6,Ext 4文件系统,Oracle 11.2.0.2数据库版本,磁盘8块本地盘镜像,可用空间是4块147G的容量。
我简要测试一下性能,创建10G文件,大约26秒,393M/s:
我简要测试一下性能,创建10G文件,大约26秒,393M/s:
SQL> create tablespace eygle datafile '/data1/oradata/mobiledb/MOBILEDB/eygle01.dbf' size 10240M;操作系统IOSTAT输出:
Tablespace created.
Elapsed: 00:00:25.94
[oracle@Oracle112 ~]$ iostat -m 2初步感觉是不错的,有待于进一步测试。
Linux 2.6.32-71.el6.x86_64 (Oracle112) 02/19/2011 _x86_64_ (16 CPU)
avg-cpu: %user %nice %system %iowait %steal %idle
0.06 0.00 0.22 0.00 0.00 99.72
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 8.00 0.00 0.04 0 0
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.36 0.00 2.22 0.03 0.00 97.39
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 231.50 0.00 64.13 0 128
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.65 0.00 6.37 5.39 0.00 87.59
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 1150.00 0.00 565.60 0 1131
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.37 0.00 4.60 11.47 0.00 83.57
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 909.00 0.00 447.31 0 894
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.21 0.00 4.66 15.11 0.00 80.02
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 893.50 0.00 440.72 0 881
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.29 0.00 3.31 12.93 0.00 83.47
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 879.50 0.00 436.29 0 872
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.36 0.00 3.43 17.98 0.00 78.23
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 670.00 0.31 320.53 0 641
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
1.19 0.00 5.99 17.97 0.00 74.86
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 978.50 1.27 467.29 2 934
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.63 0.00 6.39 20.20 0.00 72.79
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 895.00 0.00 442.00 0 884
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.38 0.00 4.51 14.20 0.00 80.91
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 899.50 0.00 445.09 0 890
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.36 0.00 4.33 13.77 0.00 81.54
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 891.00 0.00 442.24 0 884
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.26 0.00 4.76 14.52 0.00 80.45
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 897.50 0.00 445.04 0 890
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.39 0.00 2.81 8.23 0.00 88.56
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 579.50 0.37 256.86 0 513
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.07 0.00 6.82 0.03 0.00 93.08
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 256.00 0.00 92.04 0 184
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.03 0.00 6.44 0.09 0.00 93.44
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 429.00 0.00 152.04 0 304
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.14 0.00 2.01 0.85 0.00 97.00
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 733.50 0.07 105.30 0 210
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.07 0.00 0.10 0.00 0.00 99.83
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 8.00 0.00 0.04 0 0
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.14 0.00 0.31 0.14 0.00 99.41
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 19.50 0.36 0.04 0 0
scd0 0.00 0.00 0.00 0 0
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




