Oracle database is facing slowness issues frequently on AIX server. So can anybody suggest how to fix these issues from OS end? Do we need to tune any parameter in AIX to resolve this issue?
Welcome to forums .
For dealing with slowness kind of issues on O.S or DB level needs to debug on many aspects. So as a starting point, could you please do following once.
I- Check O.S level what is happening, is it having HIGH CPU or HIGH Memory during the time you are facing issues on DB level eg--> which process is the culprit for high CPU or memory you could check it by many useful *NIX commands like top, vmstat,free(for memory).
If you find anything in above 2 points then based on that you should move with your investigation, let's say we found a query for an example which is sitting idle in system and behaving like bottle neck for it at that time you may need to reach out to application team(assuming you are only handling DB systems here) and ask them what this query is related to etc.
Kindly start investigating and do let us know how it goes then, keep learning and keep sharing knowledge. Because "The more we share knowledge, more we learn".