Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

How do I monitor packets by OS id on a UNIX box?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users How do I monitor packets by OS id on a UNIX box?
# 1  
Old 04-03-2009
How do I monitor packets by OS id on a UNIX box?
We think we may have an IO problem.

We have 2 identical Oracle servers with the exact same objects in each database. In one database, the first time a query is executed and the data is moved to SGA from disk the query takes about 40 seconds. However, in the other data base, when the query is executed and the data is moved to SGA from disk the query takes about 6 minutes.

If we execute the query the second time on each, the results are the same.

We are pretty sure that there is an I/O bottleneck on the 6 minute machine.

What command could I use on the UNIX box that will show me the OS process id and the packet transfer rate in order to check our theory?
# 2  
Old 04-03-2009
Which manufacturer and version of unix?
Which version of Oracle?
How many different computers are involved in this? It is a client-server system or is all the action taking place on the server(s)?
# 3  
Old 04-03-2009
Which manufacturer and version of unix?
OS - Sun SPARC Enterprise M4000 w/Sun OS 5.10 (64 bit)

Which version of Oracle?
10.0.2.0

How many different computers are involved in this? It is a client-server system or is all the action taking place on the server(s)?

The M400 is really only used to load Oracle into memory. All of the tablespaces reside on a Network Appliance system which consists of 168 disks referred to as an aggregate.


We believe that there is an I/O problem getting the data from the filer system to SGA on the slower server. However, the network folk think we are wrong, so, we are trying to find a way to monitor the transfer rate during the execution of the query on each box to compare the transfer rates and expose the bottleneck. We think it is a bad NIC card, but, the network folks are not helpful, so we have to find a way to prove it to the higher ups. You know what I mean?

On the faster machine, only about 10 seconds are added when the data is on disk. The slower machine adds about 6 minutes to get the same amount of data to SGA.

We are executing the exact same query on the exact same data on the exact same Oracle instance and the exact same box.

We just took the init and spfile and file volume from one and copied it to the other server and mounted it with Oracle.
# 4  
Old 04-04-2009
First check that your server NIC and your network port are set to NOT autonegotiate. Both need to be positively set to a LAN speed and full duplex. If you have to change the setting, then cold boot the server afterwards.
A Half Duplex error caused by autonegotiation is hard to detect from unix but could cause your symptoms.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Transferring the file from one UNIX box to another UNIX box

Hi Folks, I am using winscp to graphiclly move the files from one unix box to another unix box , let say one unix box crediantials is (These are dummy crediantials) xxx -->username yyy -->password and another unix box name is RRR -->username TTT -->password NOW i need to... (4 Replies)
Discussion started by: punpun66
4 Replies

2. UNIX for Dummies Questions & Answers

Linux box drops the incoming packets

Hi all, I am new to Linux kernel. we have a c file that counts the no. of sends and received packets in each interface, and indicate the user about the error/drop ration of incoming and outgoing packets. in our Linux box , the incoming packets are dropped at random interval. we have our... (1 Reply)
Discussion started by: kannandv
1 Replies

3. Shell Programming and Scripting

script to monitor mount points on linux box

Hi, the following shell script is not working on linux box sugeestions appreciated. FILE1=/tmp/check1.txt FILE2=/tmp/check2.txt df -k | awk '{if (NR != 1) print $5 $6}' > ${FILE1} awk -F"%" '{if ($1 > 90) print "Warning: Filesystem " $2 " over 90% threshold (" $1 "%)"}' ${FILE1} >... (7 Replies)
Discussion started by: prakash.gr
7 Replies

4. Shell Programming and Scripting

ftp file starting with particular name on Windows box to Unix box using shell script

Hello all ! I'm trying to write a shell script (bash) to ftp a file starting with particular name like "Latest_" that is present on a Windows box to UNIX server. Basically I want to set this script in the cron so that daily the new build that is posted on the Windows box can be downloaded to the... (2 Replies)
Discussion started by: vijayb4u83
2 Replies

5. Shell Programming and Scripting

how to compare all files in one unix box has been to copied to another unix box

Hi our unix admin has copied all files from one unix box to new unix box. We just need to confirm that all the file systems are copied properly. How to validate. (9 Replies)
Discussion started by: sravanreddym
9 Replies

6. UNIX for Dummies Questions & Answers

I need an scp command from a unix box to a windows box.

scp file="myfile.txt" todir="user@somehost:(M:drive:/somepath/)"/ Not sure I need it to go to a specific drive on the windows box (1 Reply)
Discussion started by: xgringo
1 Replies

7. Shell Programming and Scripting

Moving files from Unix box to a windows box

Hi All, I need a little help .I want to transfer a file from unix box to a windows box,but the problem i'm facing is that in windows box FTP is not enabled and currently it is nearly impssible to change setting on windows box,i can not use the ftp method ,in my shell script to transfer the file.... (2 Replies)
Discussion started by: Preet
2 Replies

8. UNIX for Dummies Questions & Answers

Running UNIX commands remotely in Windows box from Unix box – avoid entering password

I am able to run the UNIX commands in a Windows box from a UNIX box through "SSH" functionality. But whenever the SSH connection is established between UNIX and Windows, password for windows box is being asked. Is there a way to avoid asking password whenever the SSH connection is made? Can I... (1 Reply)
Discussion started by: D.kalpana
1 Replies

9. UNIX for Advanced & Expert Users

How to FTP a file generated at UNIX Box to NT Box

Hi all, I am generating a file on the Unix machine , now i want to FTP the same file to the NT machine. how can i do that and the application currently upon which i am working is a JAVA based application. I need your help. regards Ruchir (2 Replies)
Discussion started by: Ruchir
2 Replies

10. UNIX for Advanced & Expert Users

VPN client (windows Box),and Server (Unix Box)

If I want to access unix box via VPN tunnel,from windows box. What sould I configure on the windows client PC, and what should I enable on the Unix Server box ? I am using Solaris V10 intel platform, and I am using windows XP, and 2003 for client (0 Replies)
Discussion started by: zillah
0 Replies
Login or Register to Ask a Question