onstat -g spi

Posted in 1999

Willem Roos — Thu, 16 Sep 1999 08:36:14 +0200 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF000D.C62A690A Content-Type: text/plain; charset="iso-8859-1" Hi all, My server (7.30.UC2 on Unixware 7.0.0) is behaving very badly. It takes hours to do anything. Here some snippets from an "onstat -g spi": Informix Dynamic Server Version 7.30.UC2 -- On-Line -- Up 1 days 10:17:27 -- 1876144 Kbytes Spin locks with waits: Num Waits Num Loops Avg Loop/Wait Name 3 79520 26506.67 mtcb vproc_sync_lock 51934 510073 9.82 mtcb sleeping_lock 1 5 5.00 mtcb tcb_queue_lock 41 139 3.39 mtcb mutex_list_lock 3 3 1.00 mtcb cond_list_lock 868 117025 134.82 mtcb notify_lock 25662 211884 8.26 class cl_lock, class = 0 1512 15726 10.40 mutex lock, name = rstcb 1 5 5.00 mutex lock, name = session 24866 34370 1.38 mutex lock, name = timestmp 17 17 1.00 mutex lock, name = alttbl and further... 50 198 3.96 mutex lock, name = pt_300274 6 17 2.83 mutex lock, name = pt_3000a0 73 3895 53.36 tcb lock, tid = 4 1 500 500.00 tcb lock, tid = 5 29 2738 94.41 tcb lock, tid = 6 15 699 46.60 tcb lock, tid = 7 4 612 153.00 tcb lock, tid = 8 1 34 34.00 tcb lock, tid = 9 3 616 205.33 tcb lock, tid = 10 1 40 40.00 tcb lock, tid = 12 1 75 75.00 tcb lock, tid = 15 1 42 42.00 tcb lock, tid = 19 1 92 92.00 tcb lock, tid = 20 7 1344888936 192126990.86 tcb lock, tid = 32 19 351533389 18501757.32 tcb lock, tid = 34 269 17933245 66666.34 tcb lock, tid = 36 32 118869667 3714677.09 tcb lock, tid = 37 1 8175 8175.00 tcb lock, tid = 46 334 991812216 2969497.65 tcb lock, tid = 743850 3 394018 131339.33 tcb lock, tid = 744234 1 4500 4500.00 tcb lock, tid = 744326 431 4269 9.90 shmcb sh_lock 1397 25853 18.51 pool po_lock, name = global 479 15432 32.22 pool po_lock, name = mt 71 1340 18.87 pool po_lock, name = procpool 1 96 96.00 lockfr2 2 16 8.00 fast mutex, lockhash[1952] 1 7 7.00 fast mutex, lockhash[2656] 1 1 1.00 fast mutex, lockhash[23784] 1 3 3.00 fast mutex, lockhash[23785] I understand that values in column 3 should not exceed 10000. Please help. TIA /* ----------------------------------------------------- * * Willem Roos (+27) 21 980 4941 * * Forced to use M$ Outlook ## * * ----------------------------------------------------- */ ------_=_NextPart_001_01BF000D.C62A690A Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>onstat -g spi</TITLE> </HEAD> <BODY> Hi all, My server (7.30.UC2 on Unixware 7.0.0) is behaving = very badly. It takes hours to do anything. Here some = snippets from an "onstat -g spi": Informix Dynamic Server Version 7.30.UC2   = -- On-Line -- Up 1 days 10:17:27 -- 1876144 Kbytes Spin locks with waits: Num Waits   Num Loops   Avg = Loop/Wait    Name 3           = 79520       = 26506.67         mtcb = vproc_sync_lock 51934       = 510073      = 9.82           &n= bsp; mtcb sleeping_lock 1           = 5           = 5.00           &n= bsp; mtcb tcb_queue_lock 41          = 139         = 3.39           &n= bsp; mtcb mutex_list_lock 3           = 3           = 1.00           &n= bsp; mtcb cond_list_lock 868         = 117025      = 134.82           mtcb = notify_lock 25662       = 211884      = 8.26           &n= bsp; class cl_lock, class =3D 0 1512        = 15726       = 10.40            = mutex lock, name =3D rstcb 1           = 5           = 5.00           &n= bsp; mutex lock, name =3D session 24866       = 34370       = 1.38           &n= bsp; mutex lock, name =3D timestmp 17          = 17          = 1.00           &n= bsp; mutex lock, name =3D alttbl and further..

onstat -g spi

Related threads

Your privacy choices