Sponsored Content
Full Discussion: Slowness issue
Operating Systems AIX Slowness issue Post 303009312 by RavinderSingh13 on Tuesday 12th of December 2017 12:02:09 PM
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
 

10 More Discussions You Might Find Interesting

1. Linux

slowness of Linux 8.0 server

Hi, I have a Linux 8.0 Redhat installed as a server. The samba configuration was done to allowed logging in to the server from windows workstations. I have a LAN, WAN connection. However, any time the workstation is trying to make a WAN connection it slow down all the systems on the network. Can... (0 Replies)
Discussion started by: kayode
0 Replies

2. SCO

Terminal Slowness

I have attempted to2find answers to this question: When logging into tty01 the system will take 5 to 10 seconds to display each character typed. Each other terminal will login correctly and display correctly2but not the first terminal. Rebooting was suggested on several sites and this has been... (2 Replies)
Discussion started by: ypanic
2 Replies

3. HP-UX

HP-UX Intermec Label Slowness

We recently moved from a Open VMS OS to HP-UX. When printing labels on Intermec 3400 printers we are seeing a delay of up to 3 minutes before labels print. We have printers going through a DEC Term servers and Jet Direct boxes. Any suggestions what might be causing this delay? (4 Replies)
Discussion started by: BIGJIM
4 Replies

4. Solaris

Login Slowness

Hi Folks My Sun Solaris servers are waiting for a long time after keying in the User-ID. There is a big delay in getting to the password prompt. But once the password is keyed in,it goes through in a second. The servers in which i am facing this issue is an NIS client. But i am facing this... (7 Replies)
Discussion started by: Hari_Ganesh
7 Replies

5. Solaris

Solaris 10 Slowness

Hi, We have got 2 solaris boxes, since our inhouse application has certified on solaris environment and now we need to certify the performance of that application on Solaris environment. 1 box we have installed websphere and the other box we have installed Oracle 10.2.0.3. both are 64bit. ... (5 Replies)
Discussion started by: mp_rocket
5 Replies

6. Solaris

NIS performance slowness

Hi I have a Solaris 10 NIS server and more than 250 NIS clients out of these there are 5 main application servers, and whenever there is any compilation happens on any of the application servers (which are acting as NIS clients) entire NIS performance will come down.Can some one help me to fix... (5 Replies)
Discussion started by: nithnara
5 Replies

7. Solaris

ssh slowness

Hi admins, After changing the ip address(temperorily) ssh to that server is very slow(exactly 25 sec).But from this new ip i can ssh to other servers without any delay problem. debug1: match: Sun_SSH_1.1.1 pat Sun_SSH_1.1.1* debug1: Enabling compatibility mode for protocol 2.0 debug1:... (2 Replies)
Discussion started by: newsol
2 Replies

8. Solaris

Java Application slowness with Xmanager

Hi! I have a m3000 server with solaris 10. Clients connecting to server using Xmanager. But when they open a Java based application its very slow and some times hanging. But when I tried with VNC it works fine. Is this a BUG in Xmanager? Or Is there any method to solve this? Thanks, Charith (3 Replies)
Discussion started by: charith.upendra
3 Replies

9. Shell Programming and Scripting

Variable value substitution issue with awk command issue

Hi All, I am using the below script which has awk command, but it is not returing the expected result. can some pls help me to correct the command. The below script sample.ksh should give the result if the value of last 4 digits in the variable NM matches with the variable value DAT. The... (7 Replies)
Discussion started by: G.K.K
7 Replies

10. Solaris

Login slowness from LDOM to ZONE

Need assitance in troubleshooting steps . Below is the issue I have LDOM which has 4 zones on it . One zone logging into the server takes 13sec where as other zones are quick . Troubleshooting steps which I did - Checked /var/tmp . Not many files - We have LDAP but thought that wouldnt be... (7 Replies)
Discussion started by: ajayram_arya
7 Replies
hp-check(1)							   User Manuals 						       hp-check(1)

NAME
hp-check - Dependency/Version Check Utility DESCRIPTION
Check the existence and versions of HPLIP dependencies. (Run as 'python ./check.py' from the HPLIP tarball before installation.) SYNOPSIS
hp-check [OPTIONS] OPTIONS
Compile-time check: -c or --compile Run-time check: -r or --run Compile and run-time checks: -b or --both (default) Fix the found issues on confirmation: --fix Set the logging level: -l<level> or --logging=<level> <level>: none, info*, error, warn, debug (*default) Run in debug mode: -g (same as option: -ldebug) Output plain text only: -t This help information: -h or --help NOTES
1. For checking for the proper build environment for the HPLIP supplied tarball (.tar.gz or .run), use the --compile or --both switches. 2. For checking for the proper runtime environment for a distro supplied package (.deb, .rpm, etc), use the --runtime switch. AUTHOR
HPLIP (Hewlett-Packard Linux Imaging and Printing) is an HP developed solution for printing, scanning, and faxing with HP inkjet and laser based printers in Linux. REPORTING BUGS
The HPLIP Launchpad.net site https://launchpad.net/hplip is available to get help, report bugs, make suggestions, discuss the HPLIP project or otherwise contact the HPLIP Team. COPYRIGHT
Copyright (c) 2001-14 Hewlett-Packard Development Company, L.P. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to distribute it under certain conditions. See COPYING file for more details. Linux 15 hp-check(1)
All times are GMT -4. The time now is 04:48 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy