Comparation between ASM note [ID 373242.1] and note [ID 452924.1]

简介:

Question: Oracle Support on the note "Lun Size And Performance Impact With Asm [ID 373242.1]" and on the note "How to Prepare Storage for ASM [ID 452924.1]" say that in other things: - Maximize the number of disks in a disk group for maximum data distribution and higher I/O bandwidth - Size alone should not affect the performance of a LUN. The underlying hardware is what counts. There is no magic number for the LUN size - For larger LUNs it is recommended using a large ALLOCATION UNIT. The provieder of the Storage EMC-Vmax say that the LUNS size can be 200 GB for database OLTP.We believe that the premise or EMC_Vmax contradicts to ORACLE so instead of maximize the disks they pretend minimize the disks of the DISK GROUP. You believe that this is to be true for Storage EMC-Vmax. Answer: As mentioned in the document 373242.1.LUN size alone should not affect the performance. Size alone should not affect the performance of a LUN. The underlying hardware is what counts. There is no magic number for the LUN size. Seek the advice of the storage vendor to recommend the best configuration from a raid 1 or 5 perspective for performance and availability since this may vary between vendors. Given a database size and storage hardware you have available, our best practice recommends creating larger LUNs (if possible to reduce LUN management for the sys admins) and create LUNs from separate set of storage arrays (drives) so that LUNs are not sharing drives if possible. For larger LUNs it is recommended using a large ALLOCATION UNIT.



本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1277769

相关文章
创建asm disk 磁盘组出错! ORA-15018 And ORA-15107 (Doc ID 2678808.1)
ORA-15018: diskgroup cannot be created ORA-15107: missing or invalid ASM disk name
117 0
|
4月前
|
SQL
How To Resize An ASM Disk? (Doc ID 470209.1)
1) Please backup the database(s) contained inside the associated diskgroup. 2) Then shutdown the databases contained inside the associated diskgroup. 3) Dismount the associated diskgroup to verify no client database connections are accessing this specific diskgroup: SQL> alter diskgroup <diskgro
36 2
|
Oracle 关系型数据库 Linux
ASMFD (ASM Filter Driver) Support on OS Platforms (Certification Matrix). (文档 ID 2034681.1)
1) Starting with Oracle Grid Infrastructure 12C Release 1 (12.1.0.2), Oracle ASM Filter Driver (Oracle ASMFD) is installed with an Oracle Grid Infrastructure installation.
2698 0
|
存储 Oracle 关系型数据库
【MOS】零宕机迁移ASM磁盘组到另一个SAN/磁盘阵列/DAS的准确步骤 (文档 ID 1946664.1)
【MOS】零宕机时间迁移 ASM 磁盘组到另一个 SAN/磁盘阵列/DAS 的准确步骤 (文档 ID 1946664.1) 文档内容 目标   提问,获得帮助,并分享您对于这篇文档的经验。
1184 0
|
存储 Oracle 关系型数据库
Oracle 11gR2 restart 单机使用asm存储 主机名发生更改处理过程 (文档 ID 986740.1)
How to Reconfigure Oracle Restart (文档 ID 986740.1) In this Document Goal ...
1047 0
|
Oracle 关系型数据库
How to Copy ASM Files Across Nodes [ID 1147859.1]
  How to Copy ASM Files Across Nodes [ID 1147859.1] --------------------------------------------------------------------...
1013 0
|
SQL Oracle 关系型数据库
How to move ASM spfile to a different disk group [ID 1082943.1]
  How to move ASM spfile to a different disk group [ID 1082943.1] Goal The goal is to move ASM spfile from one disk group to another.
1234 0
|
Oracle 关系型数据库 Linux
How to use ASMCA in silent mode to configure ASM for a stand-alone server [ID 1068788.1]
  How to use ASMCA in silent mode to configure ASM for a stand-alone server [ID 1068788.
996 0
|
Linux 关系型数据库 Oracle
ASM REACTING TO PARTITION ERRORS [ID 1062954.1]
  ASM REACTING TO PARTITION ERRORS [ID 1062954.1] ----------------------------------------------------------------------...
976 0