Login or Register to Ask a Question and Join Our Community


AIX

Lsof command giving while loop

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems AIX Lsof command giving while loop
# 1  
Old 03-27-2014
Lsof command giving while loop
Hello,

There is a process in AIX which is actually a oracle database user session but is running very slow When I use lsof it give below output

Code:
lsof /proc/21955180
 In while loop:256
 In while loop:256
 In while loop:256
 In while loop:256
Value of I :183          np:1024


Please suggest what does this while loop mean?

Best regards,
Vishal
# 2  
Old 03-27-2014
  1. Define slow: Is the user sending SQL statements that take long to process/return? If yes, maybe check if the query uses indices or use a EXPLAIN PLAN, which will show what "costs" the query has and where improvements can be done. Use Google and you will find lots of helpful documents.
    It can also be that there is another problem like a performance problem on the box, etc. Do other users/jobs have the same problem?
  2. The command you use will try to find associated processes for the directory /proc/21955180. This will not work the way you want it.
    You should specify the correct switch for a PID, which is -p
    This will most probably be the least thing to check why the connection or processing of queries is slow.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Lsof command

Hi, I am trying to find the files in a specific directory that are currently in open state. I need this information to archive the old files that are not active in the directory. I get the following output when I try the command $ lsof +d '/var/tmp/'|awk '{print $9}'|sort -u NAME... (1 Reply)
Discussion started by: ryzen7
1 Replies

2. Shell Programming and Scripting

CUT command not giving correct result inside loop

Hi, i have a source file and have 3 columns and separated by "|" .i want to split this 3 columns in different variable.When i am executing this values indivisually giving correct result but when the same execute inside a for loop,it's giving issues. Src file(jjj.txt) -------... (8 Replies)
Discussion started by: raju2016
8 Replies

3. Shell Programming and Scripting

For loop not giving expected output

#cat /tmp/input old_array old_dev new_dev new_array 0577 008AB 01744 0125 0577 008AC 01745 0125 0577 008AD 005C8 0125 0577 008AE 005C9 0125 0577 008AF 005CA 0125 0577 008B0 005CB 0125 0577 008B1 005CC 0125 cat test.sh #!/bin/ksh... (4 Replies)
Discussion started by: mbak
4 Replies

4. Shell Programming and Scripting

Grep command giving different result for different users for same command

Hello, I am running below command as root user #nodetool cfstats tests | grep "Memtable switch count" Memtable switch count: 12 Where as when I try to run same command as another user it gives different result. #su -l zabbix -s /bin/bash -c "nodetool cfstats tests | grep "Memtable switch... (10 Replies)
Discussion started by: Pushpraj
10 Replies

5. Solaris

Difference between fuser and lsof command

Hi, Can anyone explain me the difference between fsuer and lsof commands. As per my knowledge both the commands are used to find the processes used by the current file system or user. Apart from that what is the major difference between these commands (3 Replies)
Discussion started by: rogerben
3 Replies

6. Shell Programming and Scripting

simulation of wc command giving problems

Hello, i am developing a simple shell script for simulation of wc command but it's not working.Please tell me what is the problem. I have commented the problematic line if then echo "<Improper Usage>" echo "wcassg <options> file" else eval file=\$$# if then chars=0 words=0... (2 Replies)
Discussion started by: salman4u
2 Replies

7. UNIX for Dummies Questions & Answers

Last Command not giving year

Hi All, i want the last login details along with year. i tried below command but not giving me the year of last login. last <$Userid> | head -1 i heard that if it is current year then it wont display the year else it will display the year. is it so? if yes then , is there any way of... (1 Reply)
Discussion started by: ani_rvce
1 Replies

8. Shell Programming and Scripting

Last Command not giving year

Hi All, i want the last login details along with year. i tried below command but not giving me the year of last login. last <$Userid> | head -1 i heard that if it is current year then it wont display the year else it will display the year. is it so? if yes then , is there any way of... (1 Reply)
Discussion started by: ani_rvce
1 Replies

9. UNIX for Dummies Questions & Answers

require alternate command for lsof

Using lsof command i can find out which process-id is associated with the port. lsof -i :51000 . But as part of process i cant have lsof in the server. I am using sun solaris 8 and only kshell. Is there a way to find out which process is using the above port. as of now i am gettn port... (1 Reply)
Discussion started by: logic0
1 Replies

10. AIX

command lsof

hello Sorry but i don't understand very well the lsof command with the man. Can you explain to me what is the use of this command ? thank you (2 Replies)
Discussion started by: pascalbout
2 Replies
Login or Register to Ask a Question