Have you a test load to regenerate on demand issue ?
Have you opened a case with EMC ?
Having a reproducible test case will assist in determining is it the oracle database in isolation or due to a mix of workloads.
You mentioned cache misses are an issue. Providing a reproducible test case allows you to isolate database IO from other sources to determine is database traffic in isolation sufficient to create cache misses, which is normally caused by random IO rather than full table reads.
Davood Teymoori
1 Rookie
•
21 Posts
0
May 13th, 2022 05:00
The issue was related to “max_sectors_kb” value on Linux.
I think that EMC should add recommendation value to best practices or connectivity guide for EMC Unity.
Also read my blog post about that: I/O Block Size Best Practice on EMC All Flash/Hybrid Flash Array and Linux (Physical And Virtual) - Davoud Teimouri - Virtualization and Data Center
cadencep45
3 Apprentice
•
318 Posts
0
December 23rd, 2021 04:00
when you say sometimes..
Have you a test load to regenerate on demand issue ?
Have you opened a case with EMC ?
Having a reproducible test case will assist in determining is it the oracle database in isolation or due to a mix of workloads.
You mentioned cache misses are an issue. Providing a reproducible test case allows you to isolate database IO from other sources to determine is database traffic in isolation sufficient to create cache misses, which is normally caused by random IO rather than full table reads.