关于asm上使用filesystemio_options初始化参数的问题
来源:互联网 发布:psv重构数据库 编辑:程序博客网 时间:2024/06/05 06:00
关于asm上使用filesystemio_options初始化参数的问题。
昨天有个哥们问我,他的数据库是linux x86-64bit下的rac(使用asm),设置filesystemio_options初始化参数能提高数据库性能么?
我查了一下mos文章,Things To Consider For Setting filesystemio_options And disk_asynch_io (文档 ID 1987437.1)
在该文章中的“File System–specific Notes”部分,有如下论述
File System–specific Notes
Raw device access to disks does not involve a file system. The filesystemio_options parameters is always ignored and direct I/O is always used. Under Linux, block devices are also treated this way.
Direct use of raw or block devices is not supported as of 12c.
ACFSACFS is not supported for database files that can be stored directly in ASM, including data files, redo files, and control files, but there is an exception for Linux Exadata. SeeDocument 1929629.1 and Document 1369107.1.
ASM---->此处Oracle bypasses the file system layer for ASM. Thefilesystemio_options parameters is always ignored and direct I/O is always used. SeeDocument 751463.1 for more.---->此处FUSE (Linux)Direct I/O cannot be enabled on FUSE-based file systems.
JFS (IBM)Not to be confused with JFS or OnlineJFS on HP-UX, which is VxFS as supplied with HP-UX.
JFS comes in two versions. Version 1 of JFS (JFS1) is available on AIX only. Version 2 of JFS (JFS2) is available on several OSes, and is usually called "JFS" on operating systems other than AIX.
JFS1 does not support concurrent I/O, but JFS2 does.
NFSUsing direct I/O is recommended to avoid potential data corruption. See Document 437005.1 for more.
Whether concurrent I/O is used is controlled by the NFS server.
Direct NFS (dNFS)Oracle bypasses the file system layer when using Direct NFS. The filesystemio_options parameters is always ignored and direct I/O is always used.VxFS/JFS/OnlineJFS (Veritas)VxFS as supplied with HP-UX is known as JFS or OnlineJFS; not to be confused with IBM JFS.
Direct I/O cannot be set using filesystemio_options on platforms other than HP-UX. Instead, use the convosync=direct and mincache=direct mount options to force direct I/O or the cio option to force concurrent I/O.
Concurrent I/O is an extra option on VxFS (called "Concurrent I/O"). It is also available through the Quick IO option or ODM. Otherwise concurrency will be limited. NB: ODM is the preferred method of accessing Oracle files on VxFS.
VxFS ODMOracle bypasses the file system layer when using ODM on VxFS. The filesystemio_options parameters is always ignored and direct I/O is always used. Asynchronous I/O is supported natively by the ODM interface.ZFSZFS does not support direct I/O and consequently cannot be used with RAC.
With ZFS you can limit how much RAM the ARC consumes in certain Solaris releases. SeeDocument 1663862.1.
额外说一个很严重的bug:
- 关于asm上使用filesystemio_options初始化参数的问题
- 理解ASM(二)关于ASM实例的初始化参数
- ASM初始化参数
- ASM初始化参数
- 关于asm的隐含参数_disable_rebalance_compact
- ASM的后台进程、初始化参数和V$视图
- 修改filesystemio_options 引起的故障
- 有关STL使用上的一些注意事项。关于某些函数的参数问题。
- oracle异步IO之filesystemio_options参数初探
- 关于初始化参数列表使用注意
- 关于object在使用上的问题
- 关于jsoncpp使用上的问题
- 一道关于初始化的问题
- 关于复制初始化的问题
- 关于fluent初始化的问题
- 关于java初始化的问题
- 关于初始化列表的问题
- 关于datetimepicker初始化的问题
- 优秀文章地址总结
- XML解析
- eclipse如何修改dynamic web module version
- 1028. 人口普查(20)
- iptables
- 关于asm上使用filesystemio_options初始化参数的问题
- Java基础 Collections Arrays 增强for循环 可变参数
- jquery mobile 动态插入元素的正确渲染方法
- 怎么解决Underfitting和Overfitting问题?
- Ios开发必看,苹果粉绝不能错过
- 浙江大学PAT_甲级_1019. General Palindromic Number (20)
- MYSQL语法大全
- 十大要避免的Ext JS开发方法
- Android L——Material Design详解(视图和阴影)