Slowness issue

Tags
aix, aix 7.1, oracle 11g, performance tuning

 
Thread Tools Search this Thread
# 1  
Old 12-12-2017
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:
Mod Comment 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..."
# 2  
Old 12-12-2017
Quote:
Originally Posted by vithal
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 Smilie.

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

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
Login slowness from LDOM to ZONE ajayram_arya Solaris 7 12-07-2017 04:19 PM
Issue with wc -c and wc -m siva.pitchai Shell Programming and Scripting 4 11-03-2014 12:25 AM
Variable value substitution issue with awk command issue G.K.K Shell Programming and Scripting 7 03-03-2013 01:11 PM
Java Application slowness with Xmanager charith.upendra Solaris 3 06-16-2012 02:05 PM
Need assistance with a file issue and a terminal issue MrMagoo22 Shell Programming and Scripting 1 03-15-2012 04:39 PM
ssh slowness newsol Solaris 2 12-07-2011 08:07 PM
CP Issue telnor Shell Programming and Scripting 1 10-26-2011 09:28 AM
NIS performance slowness nithnara Solaris 5 12-20-2010 05:11 PM
ISSUE and ISSUE.NET files ejjones UNIX for Dummies Questions & Answers 0 05-05-2010 08:32 AM
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
HP-UX Intermec Label Slowness BIGJIM HP-UX 4 05-02-2008 08:46 AM
Unix Arithmatic operation issue , datatype issue thambi Shell Programming and Scripting 23 02-19-2008 07:19 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