AIX

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?

Moderator's Comments:

Please post in an adequate forum!

Hello vithal,

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).

II- Second will be I think DB side Oracle provides information to see which queries are LONG running queries eg--> Ask TOM "How to find long running queries in a database" This link could be helpful for you(though please check it once in non-prod environment for safer side).

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".

Thanks,
R. Singh