Hello, can see a few old posts about Oracle on Windows vs Linux . Maybe there are new info.
Having a customer running a heavy application on windows, it collects values from 19000 electricity meters.
Plan is to have 44000 meters when done. Performance is slow which mostly seems to be related to poor sql and
most likely a bad data modell. We have tuned the worst sql's which made it better, but we also seems to have issues with storage being a bit slow. Storage teams has worked on it and says they have done what they can. Not sure if it still is poorly configured
storage or if it is something else.
My question is moving the db to a Oracle Linux box, would we gain anything by just doing that ?
I am aware that the best tuning effort is done by design and and efficient sql statements. But we have limited access to
work on that.
Designing storage for a Oracle db today, what to think of ? I know Oracle a few years back talked about
“S.A.M.E” = Strip All Mirror Everything, still valid or what recommendations do we have ?
Thinking of using ASM…
Appreciate your feedback.
Best Regards
Magnus Johansson