Re: Delay in commands returning
<david@smooth1.co.uk> wrote in message
news:74c11349-0684-4776-b3c3-bf3c4de63334@33g2000vbe.googlegroups.com...
>> What about "time onstat -" how long does that take??
time onstat -
IBM Informix Dynamic Server Version 10.00.FC9 -- On-Line -- Up
05:25:50 -- 25968640 Kbytesreal 0m1.022s
user 0m0.006s
sys 0m0.014s
>> Before hand do onstat -z then onstat -g spi afterwards, what latches
are taken?
-bash-3.00$ time onstat -z ; time onstat - ; time onstat -g spi
IBM Informix Dynamic Server Version 10.00.FC9 -- On-Line -- Up
05:29:19 -- 25968640 Kbytesreal 0m3.049s
user 0m0.006s
sys 0m0.014s
IBM Informix Dynamic Server Version 10.00.FC9 -- On-Line -- Up
05:29:22 -- 25968640 Kbytesreal 0m1.030s
user 0m0.006s
sys 0m0.017s
IBM Informix Dynamic Server Version 10.00.FC9 -- On-Line -- Up
05:29:23 -- 25968640 KbytesSpin locks with waits:
Num Waits Num Loops Avg Loop/Wait Name
253 4161300 16447.83 mtcb sleeping_lock
1 209 209.00 vproc vp_lock, id = 5
2 2 1.00 vproc vp_lock, id = 6
1 44 44.00 vproc vp_lock, id = 8
1 1 1.00 vproc vp_lock, id = 9
2 247 123.50 vproc vp_lock, id = 15
1 1 1.00 vproc vp_lock, id = 18
1 38 38.00 vproc vp_lock, id = 19
1 49 49.00 vproc vp_lock, id = 22
1 3 3.00 vproc vp_lock, id = 23
4 1427 356.75 vproc vp_lock, id = 24
22 404 18.36 fast mutex, flush
real 0m8.362s
user 0m7.171s
sys 0m0.181s