understanding Strace output
Hello All
I attempted to ascertain whether I have an issue with my the SAN storage.
Therfore I ran a connected to an oracle 11g database and used the szstem ID of my process.
I then ran the following command :
strace -cp 26806
I then ran my SQL statement once it had return my values etc I cancelled out and these are the results I got.
[oracle@xxxx tmp]$ strace -cp 26806
Process 26806 attached - interrupt to quit
Process 26806 detached
% time seconds usecs/call calls errors syscall
----------- --------- ----------------
60.76 1.167108 34 34379 read
25.56 0.490949 3 176282 poll
10.01 0.192197 0 444382 177753 recvmsg
2.15 0.041320 0 88878 sendmsg
1.33 0.025533 0 183723 times
0.11 0.002168 0 14809 getrusage
0.05 0.001027 0 2956 write
0.01 0.000215 31 7 munmap
0.01 0.000192 2 82 mmap
0.00 0.000000 0 7 semctl
100.00 1.920709 945505 177753 total
From the output the whole thing took 1.92 secs. Does this mean the SAN is really responding in that time or should I not use strace to determine that?
Thanks in advance