The main improvement you'll see is at the Oracle level. You should get better latency/throughput from direct_path_read and db_file_parallel_read operations. You won't see anything notable in the more common random read latency, but to keep things running cleanly read_realloc is a general best practice when spinning disk is involved. It doesn't do anything useful with SSD aggregates and I think it's impossible to set in the latest versions of ONTAP anyway.
As a side effect, the overall loading on ONTAP would go down as sequential IO becomes more efficient, but I'm not sure how you'd actually prove that it's occurring unless the currently layout is truly awful.
-----Original Message----- From: toasters-bounces@teaparty.net [mailto:toasters-bounces@teaparty.net] On Behalf Of Ehrenwald, Ian Sent: Wednesday, March 08, 2017 4:48 PM To: toasters@teaparty.net Subject: Measurable effects of read_realloc?
Hello Is there a way within an SVM (cDOT 8.3.2P5) to observe the results of setting read_realloc to “on” in Oracle database flexvols? I told my DBAs that I’d be enabling this option on a couple eligible flexvols per day to see if we’d benefit from it, and we all are curious to see if it has benefited us. What sort of measurable things would someone see? Decreased latency and increased throughput after a couple weeks of heavy read load? I have OCUM/OCPM and LogicMonitor to view filer-side stats, and my DBAs have OEM to view stats coming from Oracle. Thanks for any hints.
-- Ian Ehrenwald Senior Infrastructure Engineer Hachette Book Group, Inc. 1.617.263.1948 / ian.ehrenwald@hbgusa.com
This may contain confidential material. If you are not an intended recipient, please notify the sender, delete immediately, and understand that no disclosure or reliance on the information herein is permitted. Hachette Book Group may monitor email to and from our network.
_______________________________________________ Toasters mailing list Toasters@teaparty.net http://www.teaparty.net/mailman/listinfo/toasters