ITPub博客

首页 > 数据库 > Oracle > AIX LVM JFS Blocksize引起的oracle数据库redo性能问题

AIX LVM JFS Blocksize引起的oracle数据库redo性能问题

原创 Oracle 作者:icycastle 时间:2016-03-02 09:44:48 0 删除 编辑

近期,一套Oracle 11.2.0.2数据库进行了存储迁移,期间重建了数据库的文件系统,之后发现log files sync等待事件平均耗时增加了一倍,应用队列有明显的阻塞。
通过多方排查,最终定位到AIX操作系统redo文件系统的blocksize有特别要求,如下是metalink文档说明。
 

Db_block_size Requirements For Direct IO / Concurrent IO (Doc ID 418714.1)

To Bottom


In this Document

Goal

Solution


APPLIES TO:

Oracle Database - Enterprise Edition - Version 9.2.0.6 to 11.2.0.3 [Release 9.2 to 11.2]
IBM AIX on POWER Systems (64-bit)
***Checked for relevance on 20-Jan-2012***

GOAL

Running benchmarks with Direct IO and Concurrent IO. 

disk_asynch_io is set to true, filesystemio_options = setall and db_block_size=8k

Will DIO and CIO be used when the operating system uses 4k blocks and Oracle is set to 8k blocks or is it required to set the db_block_size to 4k so it matches exactly what the OS has?

SOLUTION

The following is extracted from IBM paper- Oracle Architecture and Tuning on AIX.
Please refer to
  (c) 2011 International Business Machines, Inc. - IBM Americas Advanced Technical Support
  Oracle Architecture and Tuning on AIX
  Version: 2.20
  Date : 21 September 2011
  Section: 2.3.8. JFS2 file system DIO/CIO mount options, p.54

For applications such as Oracle Database that provide their own I/O serialization mechanisms, JFS2 (beginning with AIX 5.2.10) offers the Concurrent I/O (CIO) option. Under Concurrent I/O, multiple threads may simultaneously perform reads and writes on a shared file. Applications that do not enforce serialization for accesses to shared files (including operating system level utilities) should not use Concurrent I/O, as this could result in data corruption due to competing accesses and /or severe performance penalties.

Concurrent I/O should only be used for Oracle .dbf files (data & index, rbs or undo, system and temp). When used for online redo logs or control files, these files should be isolated in their own JFS2 filesystem(s) that have been created with agblksize=512.
Filesystem containing .dbf files should be created with agblksize=2048 if DB_BLOCK_SIZE=2k, or agblksize=4096 if DB_BLOCK_SIZE>= 4k. Failure to implement these agblksize guidelines is likely to result in a severe performance penalty.

Do not under any circumstances, use CIO mount option for the filesystem containing the Oracle binaries. Additionally, do not use DIO/CIO options for filesystem containing archive logs or any other files not already discussed.

NOTE:
The following command can be used to query agblksize (needs to be run as root):

% lsfs -q <filesystem_name>

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/802647/viewspace-2022947/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2012-03-15

  • 博文量
    9
  • 访问量
    14406