Home Man
Search
Today's Posts
Register

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

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

Login to Reply

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

Last edited by RudiC; 12-12-2017 at 12: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 .

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
Login to Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Login slowness from LDOM to ZONE ajayram_arya Solaris 7 12-07-2017 03:19 PM
Java Application slowness with Xmanager charith.upendra Solaris 3 06-16-2012 01:05 PM
ssh slowness newsol Solaris 2 12-07-2011 07:07 PM
NIS performance slowness nithnara Solaris 5 12-20-2010 04:11 PM
Solaris 10 Slowness mp_rocket Solaris 5 03-29-2010 10:23 AM
Login Slowness Hari_Ganesh Solaris 7 07-09-2009 05:44 AM
HP-UX Intermec Label Slowness BIGJIM HP-UX 4 05-02-2008 07:46 AM
Unix Arithmatic operation issue , datatype issue thambi Shell Programming and Scripting 23 02-19-2008 06:19 AM
Terminal Slowness ypanic SCO 2 10-25-2005 05:34 PM
slowness of Linux 8.0 server kayode Linux 0 12-07-2004 08:38 AM


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

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
UNIX.COM Login
Username:
Password:  
Show Password