troubleshooting slow I/O performance.
From: Chris Stephens <cstephens16_at_gmail.com>
Date: Mon, 07 May 2018 13:59:14 +0000
Message-ID: <CAEFL0sztKuHEv9itZn74=x4rM9Gx3jOYDAFBHqA4=-mkx4G7QA_at_mail.gmail.com>
We have a new 5 node 12.2 RAC system that is not performing the way we want.
Date: Mon, 07 May 2018 13:59:14 +0000
Message-ID: <CAEFL0sztKuHEv9itZn74=x4rM9Gx3jOYDAFBHqA4=-mkx4G7QA_at_mail.gmail.com>
We have a new 5 node 12.2 RAC system that is not performing the way we want.
The glaring issue is that "db file sequential read"'s are taking ~10ms. before i lob this over to the storage administrators, are there any possible areas in the clusterware/database configuration that I should investigate first? i have root access to all of the nodes. is there any information i can collect that would expedite the process of figuring out why we have such slow I/O times?
slow i/o was discovered by running slob. if you don't know about that tool, you should. we all owe kevin a debt of gratitude. ;)
if nothing else, i hope to learn a little more about storage than i currently know (which isn't much).
thanks for any help.
chris
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 07 2018 - 15:59:14 CEST