跳转到主内容

ONTAP 处理层的高延迟是否会影响 Oracle 重做工作负载性能?

Views:
6
Visibility:
Public
Votes:
0
Category:
ontap-9
Specialty:
perf
Last Updated:

适用场景

ONTAP 9.x

问题解答

Oracle Redo 会记录工作负载在一个周期内的工作负载,并且本质上会非常繁重。突发写入工作负载可能会使处理层不堪重负,并在 WAFL 中显示等待时间。但是,这是完全正常的;重做日志记录一次可以写入大量 MB 。 


Oracle 重做日志写入是一个由可变大小的 IO 组成的单线程,可以在突发情况下将大量 IO 写入 ONTAP 。突发通常看起来是一个严重的延迟问题,但它很少是一个实际问题。

Oracle 执行的 IO 效率非常高,并且并发性通常较低。只需确保 [1] 严格遵循和实施技术报告 3633 中有关内核参数,挂载选项和 ONTAP 选项的所有说明即可。  如果这些参数配置不当,则会比其他 IO 更严重地损害顺序 IO 性能。

追加信息

使用以下知识库分析使用自动工作负载存储库( Automatic Workload Repository , AWR )的 Oracle 性能

https://kb.netapp.com/Advice_and_Tro...ormance_Issues

 

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.