Unix/Linux Go Back    


AIX AIX is IBM's industry-leading UNIX operating system that meets the demands of applications that businesses rely upon in today's marketplace.

Slowness issue

AIX


Tags
aix 7.1, oracle 11g, performance tuning

Reply    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 12-12-2017   -   Original Discussion by vithal
vithal's Unix or Linux Image
vithal vithal is offline
Registered User
 
Join Date: Dec 2017
Last Activity: 13 December 2017, 7:44 AM EST
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
IBM Slowness issue

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:
Slowness issue Please post in an adequate forum!

Last edited by RudiC; 12-12-2017 at 01:30 PM.. Reason: Moved thread from "Post here to contact Site Moderators..."
Sponsored Links
    #2  
Old Unix and Linux 12-12-2017   -   Original Discussion by vithal
RavinderSingh13's Unix or Linux Image
RavinderSingh13 RavinderSingh13 is offline Forum Advisor  
Registered User
 
Join Date: May 2013
Last Activity: 24 February 2018, 1:51 AM EST
Location: Chennai
Posts: 2,697
Thanks: 601
Thanked 1,282 Times in 1,152 Posts
Quote:
Originally Posted by vithal View Post
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?
Hello vithal,

Welcome to forums Linux.

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
Sponsored Links
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
ssh slowness newsol Solaris 2 12-07-2011 08:07 PM
Solaris 10 Slowness mp_rocket Solaris 5 03-29-2010 11:23 AM
Login Slowness Hari_Ganesh Solaris 7 07-09-2009 06:44 AM
Terminal Slowness ypanic SCO 2 10-25-2005 06:34 PM
slowness of Linux 8.0 server kayode Linux 0 12-07-2004 09:38 AM



All times are GMT -4. The time now is 06:13 AM.