Re: troubleshooting slow I/O performance.

Some details would help:

• ASM or FS? Type of FS?
• LUNs? Numbers, sizes?
• metal? SSD? Type of path to the disks?

On Mon, 7 May 2018, 21:00 Chris Stephens, <cstephens16_at_gmail.com> wrote:

> 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-l