How to know if a session is hanged already?

Posted in 2013

JACK PAPA — Wed, 18 Sep 2013 05:28:07 — source: IIUG Forums & Mailing Lists

Hi All, IDS9.4 OS=Solaris I just want to ask how can i know if a certain session already hanged? I'm seeing just : 7924171 sqlexec 9651b320 Y--P--- 2264 cond wait(netnorm) 7924168 sqlexec a4059ff0 Y--P--- 2264 cond wait(netnorm) 7924166 sqlexec 991169f8 Y--P--- 2264 cond wait(netnorm) 7924153 sqlexec 94af49e8 Y--P--- 2264 cond wait(netnorm) 7924107 sqlexec 9c4e2ab8 Y--P--- 2264 cond wait(netnorm) 7924106 sqlexec a40450c8 Y--P--- 2264 cond wait(netnorm) 7923965 sqlexec 99132ce8 Y--P--- 2264 cond wait(netnorm) 7923964 sqlexec 99117628 Y--P--- 2264 cond wait(netnorm) 7923955 sqlexec 94af1310 Y--P--- 2264 cond wait(netnorm) 7923954 sqlexec 96538858 Y--P--- 2264 cond wait(netnorm) 7923953 sqlexec 90298ff8 Y--P--- 2264 cond wait(netnorm) 7923927 sqlexec 9912c550 Y--P--- 2264 cond wait(netnorm) 7923926 sqlexec 90294cf0 Y--P--- 2264 cond wait(netnorm) 7923921 sqlexec 94aefab0 Y--P--- 2264 cond wait(netnorm) 7923920 sqlexec 9c4ef9e8 Y--P--- 2264 cond wait(netnorm) 7923902 sqlexec 94b08ce0 Y--P--- 2264 cond wait(netnorm) 7923901 sqlexec 9c508600 Y--P--- 2264 cond wait(netnorm) 7923838 sqlexec 96533f38 Y--P--- 2264 cond wait(netnorm) 7923837 sqlexec 902a7788 Y--P--- 2264 cond wait(netnorm) 7923685 sqlexec 9c4f4920 Y--P--- 2264 cond wait(netnorm) 7923684 sqlexec 9c4faaa0 Y--P--- 2264 cond wait(netnorm) 7923677 sqlexec 90296b68 Y--P--- 2264 cond wait(netnorm) 7923676 sqlexec 991263d0 Y--P--- 2264 cond wait(netnorm) 7923621 sqlexec 9c4ed558 Y--P--- 2264 cond wait(netnorm) 7923615 sqlexec 96525dc0 Y--P--- 2264 cond wait(netnorm) 7923608 sqlexec a405f540 Y--P--- 2264 cond wait(netnorm) 7923607 sqlexec 94b03178 Y--P--- 2264 cond wait(netnorm) 7923545 sqlexec 902a52f8 Y--P--- 2264 cond wait(netnorm) 7923544 sqlexec 94afd610 Y--P--- 2264 cond wait(netnorm) 7923541 sqlexec 9c5030b0 Y--P--- 2264 cond wait(netnorm) 7923540 sqlexec 94b01918 Y--P--- 2264 cond wait(netnorm) 7923482 sqlexec a404dcf0 Y--P--- 2264 cond wait(netnorm) 7923481 sqlexec 94ae1f50 Y--P--- 2264 cond wait(netnorm) 7923449 sqlexec 9c4e5560 Y--P--- 2264 cond wait(netnorm) 7923448 sqlexec 99110260 Y--P--- 2264 cond wait(netnorm) 7923414 sqlexec 9913ace0 Y--P--- 2264 cond wait(netnorm) 7923413 sqlexec 94b0c3b8 Y--P--- 2264 cond wait(netnorm) 7923404 sqlexec 965226e8 Y--P--- 2264 cond wait(netnorm) 7923403 sqlexec 9913e3b8 Y--P--- 2264 cond wait(netnorm) 7923294 sqlexec a4048188 Y--P--- 2264 cond wait(netnorm) 7923293 sqlexec 9652c558 Y--P--- 2264 cond wait(netnorm) 7923230 sqlexec 94b086c8 Y--P--- 2264 cond wait(netnorm) 7923229 sqlexec 9029df30 Y--P--- 2264 cond wait(netnorm) 7923164 sqlexec a404a000 Y--P--- 2264 cond wait(netnorm) 7923163 sqlexec 9911ad00 Y--P--- 2264 cond wait(netnorm) 7923080 sqlexec 96540238 Y--P--- 2264 cond wait(netnorm) 7923079 sqlexec 9653fc20 Y--P--- 2264 cond wait(netnorm) 7922437 sqlexec 9912a0c0 Y--P--- 2264 cond wait(netnorm) 7922436 sqlexec 9651e9f8 Y--P--- 2264 cond wait(netnorm) 7922366 sqlexec 99115dc8 Y--P--- 2264 cond wait(netnorm) 7922363 sqlexec 99125db8 Y--P--- 2264 cond wait(netnorm) 7922054 sqlexec 9652d7a0 Y--P--- 2264 cond wait(netnorm) 7922052 sqlexec a4052c28 Y--P--- 2264 cond wait(netnorm) 7921981 sqlexec a404d0c0 Y--P--- 2264 cond wait(netnorm) 7921980 sqlexec 99112d08 Y--P--- 2264 cond wait(netnorm) 7921650 sqlexec a404f550 Y--P--- 2264 cond wait(netnorm) 7921649 sqlexec 965432f8 Y--P--- 2264 cond wait(netnorm) 7921149 sqlexec 99138850 Y--P--- 2264 cond wait(netnorm) 7921148 sqlexec 94b00ce8 Y--P--- 2264 cond wait(netnorm) 7920862 sqlexec 99121498 Y--P--- 2264 cond wait(netnorm) 7920861 sqlexec 9653d178 Y--P--- 2264 cond wait(netnorm) 7920783 sqlexec a4051ff8 Y--P--- 2264 cond wait(netnorm) 7920779 sqlexec 9c4e0c40 Y--P--- 2264 cond wait(netnorm) 7920685 sqlexec 99128860 Y--P--- 2264 cond wait(netnorm) 7920684 sqlexec 94b02b60 Y--P--- 2264 cond wait(netnorm) 7920649 sqlexec a405ca98 Y--P--- 2264 cond wait(netnorm) 7920648 sqlexec 9c4f6798 Y--P--- 2264 cond wait(netnorm) 7920555 sqlexec 94ae37b0 Y--P--- 2264 cond wait(netnorm) 7920554 sqlexec 96541a98 Y--P--- 2264 cond wait(netnorm) 7920357 sqlexec 9911a6e8 Y--P--- 2264 cond wait(netnorm) 7920356 sqlexec 94ae9930 Y--P--- 2264 cond wait(netnorm) 7920350 sqlexec 94af1928 Y--P--- 2264 cond wait(netnorm) 7920349 sqlexec 94af1f40 Y--P--- 2264 cond wait(netnorm) 7920082 sqlexec 9c4f4308 Y--P--- 2264 cond wait(netnorm) 7920081 sqlexec 9c4fc300 Y--P--- 2264 cond wait(netnorm) 7920068 sqlexec 96517630 Y--P--- 2264 cond wait(netnorm) 7920067 sqlexec 9653c548 Y--P--- 2264 cond wait(netnorm) 7919947 sqlexec 965469d0 Y--P--- 2264 cond wait(netnorm) 7919945 sqlexec 965369e0 Y--P--- 2264 cond wait(netnorm) 7919774 sqlexec 9c4d9878 Y--P--- 2264 cond wait(netnorm) 7919773 sqlexec 9c4f6db0 Y--P--- 2264 cond wait(netnorm) 7919699 sqlexec 94b07a98 Y--P--- 2264 cond wait(netnorm) 7919694 sqlexec 9c4f3cf0 Y--P--- 2264 cond wait(netnorm) 7919232 sqlexec 9c4e3d00 Y--P--- 2264 cond wait(netnorm) 7919231 sqlexec a404a618 Y--P--- 2264 cond wait(netnorm) 7919222 sqlexec 94ae49f8 Y--P--- 2264 cond wait(netnorm) 7919221 sqlexec a404e920 Y--P--- 2264 cond wait(netnorm) 7918985 sqlexec a4053240 Y--P--- 2264 cond wait(netnorm) 7918984 sqlexec 9c4f6180 Y--P--- 2264 cond wait(netnorm) 7917690 sqlexec 9c500c20 Y--P--- 2264 cond wait(netnorm) 7917689 sqlexec 9c4f0618 Y--P--- 2264 cond wait(netnorm) 7917351 sqlexec 99134b60 Y--P--- 2264 cond wait(netnorm) 7917350 sqlexec 902a7da0 Y--P--- 2264 cond wait(netnorm) 7916911 sqlexec 9653f608 Y--P--- 2264 cond wait(netnorm) 7916910 sqlexec 9c4de198 Y--P--- 2264 cond wait(netnorm) 7916783 sqlexec 9652bf40 Y--P--- 2264 cond wait(netnorm) 7916779 sqlexec 9c4e79f0 Y--P--- 2264 cond wait(netnorm) 7916282 sqlexec 9c4feda8 Y--P--- 2264 cond wait(netnorm) 7916281 sqlexec 9913d170 Y--P--- 2264 cond wait(netnorm) 7916073 sqlexec 96537c28 Y--P--- 2264 cond wait(netnorm) 7916072 sqlexec 94ae9f48 Y--P--- 2264 cond wait(netnorm) 7916022 sqlexec 96535798 Y--P--- 2264 cond wait(netnorm) 7916021 sqlexec 9652cb70 Y--P--- 2264 cond wait(netnorm) 7915703 sqlexec 9c4f79e0 Y--P--- 2264 cond wait(netnorm) 7915700 sqlexec 965257a8 Y--P--- 2264 cond wait(netnorm) 7915615 sqlexec 902a4ce0 Y--P--- 2264 cond wait(netnorm) 7915614 sqlexec 9912ddb0 Y--P--- 2264 cond wait(netnorm) 7915584 sqlexec 9c4eb0c8 Y--P--- 2264 cond wait(netnorm) 7915518 sqlexec a4046928 Y--P--- 2264 cond wait(netnorm) 7915517 sqlexec 94af37a0 Y--P--- 2264 cond wait(netnorm) 7915447 sqlexec 94aedc38 Y--P--- 2264 cond wait(netnorm) 7915398 sqlexec 9913a0b0 Y--P--- 2264 cond wait(netnorm) 7915397 sqlexec 9c4e9e80 Y--P--- 2264 cond wait(netnorm) 7915354 sqlexec a4050db0 Y--P--- 2264 cond wait(netnorm) 7915353 sqlexec 9c4e1258 Y--P--- 2264 cond wait(netnorm) 7915345 sqlexec a405b238 Y--P--- 2264 cond wait(netnorm) 7915128 sqlexec 9913e9d0 Y--P--- 2264 cond wait(netnorm) 7915122 sqlexec 94afee70 Y--P--- 2264 cond wait(netnorm) 7914936 sqlexec 9652f618 Y--P--- 2264 cond wait(netnorm) 7914933 sqlexec 99138e68 Y--P--- 2264 cond wait(netnorm) 7914281 sqlexec 9029d300 Y--P--- 2264 cond wait(netnorm) 7914280 sqlexec 94afcff8 Y--P--- 2264 cond wait(netnorm) 7914230 sqlexec 9912e9e0 Y--P--- 2264 cond wait(netnorm) 7914224 sqlexec 96540850 Y--P--- 2264 cond wait(netnorm) 7914107 sqlexec 9912bf38 Y--P--- 2264 cond wait(netnorm)@@NL

↪ replying to JACK PAPA

Khaled Bentebal — Wed, 18 Sep 2013 12:25:11 — source: IIUG Forums & Mailing Lists

Hi Jack, The flags for your sessions are important. Here is the signification for your flags: Flags in position 1 B - Waiting on Buffer C - Waiting on checkpoint G - Waiting on a logocal log buffer write L - Waiting on a lock S - Waiting on a mutex T - Waiting on a transaction Y - Waiting on condition X - Waiting on a transaction rollback or cleanup All of your sessions have a Y flag which means that all of the sessions are not doing anything but just waiting for an action from the user. You do not have any blocking situation or non are waiting for a resource. None of the sessions are hanged. Hope that this helps. Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Président UGIF - User Group Informix France IIUG - Board of Directors Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr Le 18/09/13 07:28, JACK PAPA a écrit : > Hi All, > > IDS9.4 > OS=Solaris > I just want to ask how can i know if a certain session already hanged? I'm > seeing just : > > 7924171 sqlexec 9651b320 Y--P--- 2264 cond wait(netnorm) > 7924168 sqlexec a4059ff0 Y--P--- 2264 cond wait(netnorm) > 7924166 sqlexec 991169f8 Y--P--- 2264 cond wait(netnorm) > 7924153 sqlexec 94af49e8 Y--P--- 2264 cond wait(netnorm) > 7924107 sqlexec 9c4e2ab8 Y--P--- 2264 cond wait(netnorm) > 7924106 sqlexec a40450c8 Y--P--- 2264 cond wait(netnorm) > 7923965 sqlexec 99132ce8 Y--P--- 2264 cond wait(netnorm) > 7923964 sqlexec 99117628 Y--P--- 2264 cond wait(netnorm) > 7923955 sqlexec 94af1310 Y--P--- 2264 cond wait(netnorm) > 7923954 sqlexec 96538858 Y--P--- 2264 cond wait(netnorm) > 7923953 sqlexec 90298ff8 Y--P--- 2264 cond wait(netnorm) > 7923927 sqlexec 9912c550 Y--P--- 2264 cond wait(netnorm) > 7923926 sqlexec 90294cf0 Y--P--- 2264 cond wait(netnorm) > 7923921 sqlexec 94aefab0 Y--P--- 2264 cond wait(netnorm) > 7923920 sqlexec 9c4ef9e8 Y--P--- 2264 cond wait(netnorm) > 7923902 sqlexec 94b08ce0 Y--P--- 2264 cond wait(netnorm) > 7923901 sqlexec 9c508600 Y--P--- 2264 cond wait(netnorm) > 7923838 sqlexec 96533f38 Y--P--- 2264 cond wait(netnorm) > 7923837 sqlexec 902a7788 Y--P--- 2264 cond wait(netnorm) > 7923685 sqlexec 9c4f4920 Y--P--- 2264 cond wait(netnorm) > 7923684 sqlexec 9c4faaa0 Y--P--- 2264 cond wait(netnorm) > 7923677 sqlexec 90296b68 Y--P--- 2264 cond wait(netnorm) > 7923676 sqlexec 991263d0 Y--P--- 2264 cond wait(netnorm) > 7923621 sqlexec 9c4ed558 Y--P--- 2264 cond wait(netnorm) > 7923615 sqlexec 96525dc0 Y--P--- 2264 cond wait(netnorm) > 7923608 sqlexec a405f540 Y--P--- 2264 cond wait(netnorm) > 7923607 sqlexec 94b03178 Y--P--- 2264 cond wait(netnorm) > 7923545 sqlexec 902a52f8 Y--P--- 2264 cond wait(netnorm) > 7923544 sqlexec 94afd610 Y--P--- 2264 cond wait(netnorm) > 7923541 sqlexec 9c5030b0 Y--P--- 2264 cond wait(netnorm) > 7923540 sqlexec 94b01918 Y--P--- 2264 cond wait(netnorm) > 7923482 sqlexec a404dcf0 Y--P--- 2264 cond wait(netnorm) > 7923481 sqlexec 94ae1f50 Y--P--- 2264 cond wait(netnorm) > 7923449 sqlexec 9c4e5560 Y--P--- 2264 cond wait(netnorm) > 7923448 sqlexec 99110260 Y--P--- 2264 cond wait(netnorm) > 7923414 sqlexec 9913ace0 Y--P--- 2264 cond wait(netnorm) > 7923413 sqlexec 94b0c3b8 Y--P--- 2264 cond wait(netnorm) > 7923404 sqlexec 965226e8 Y--P--- 2264 cond wait(netnorm) > 7923403 sqlexec 9913e3b8 Y--P--- 2264 cond wait(netnorm) > 7923294 sqlexec a4048188 Y--P--- 2264 cond wait(netnorm) > 7923293 sqlexec 9652c558 Y--P--- 2264 cond wait(netnorm) > 7923230 sqlexec 94b086c8 Y--P--- 2264 cond wait(netnorm) > 7923229 sqlexec 9029df30 Y--P--- 2264 cond wait(netnorm) > 7923164 sqlexec a404a000 Y--P--- 2264 cond wait(netnorm) > 7923163 sqlexec 9911ad00 Y--P--- 2264 cond wait(netnorm) > 7923080 sqlexec 96540238 Y--P--- 2264 cond wait(netnorm) > 7923079 sqlexec 9653fc20 Y--P--- 2264 cond wait(netnorm) > 7922437 sqlexec 9912a0c0 Y--P--- 2264 cond wait(netnorm) > 7922436 sqlexec 9651e9f8 Y--P--- 2264 cond wait(netnorm) > 7922366 sqlexec 99115dc8 Y--P--- 2264 cond wait(netnorm) > 7922363 sqlexec 99125db8 Y--P--- 2264 cond wait(netnorm) > 7922054 sqlexec 9652d7a0 Y--P--- 2264 cond wait(netnorm) > 7922052 sqlexec a4052c28 Y--P--- 2264 cond wait(netnorm) > 7921981 sqlexec a404d0c0 Y--P--- 2264 cond wait(netnorm) > 7921980 sqlexec 99112d08 Y--P--- 2264 cond wait(netnorm) > 7921650 sqlexec a404f550 Y--P--- 2264 cond wait(netnorm) > 7921649 sqlexec 965432f8 Y--P--- 2264 cond wait(netnorm) > 7921149 sqlexec 99138850 Y--P--- 2264 cond wait(netnorm) > 7921148 sqlexec 94b00ce8 Y--P--- 2264 cond wait(netnorm) > 7920862 sqlexec 99121498 Y--P--- 2264 cond wait(netnorm) > 7920861 sqlexec 9653d178 Y--P--- 2264 cond wait(netnorm) > 7920783 sqlexec a4051ff8 Y--P--- 2264 cond wait(netnorm) > 7920779 sqlexec 9c4e0c40 Y--P--- 2264 cond wait(netnorm) > 7920685 sqlexec 99128860 Y--P--- 2264 cond wait(netnorm) > 7920684 sqlexec 94b02b60 Y--P--- 2264 cond wait(netnorm) > 7920649 sqlexec a405ca98 Y--P--- 2264 cond wait(netnorm) > 7920648 sqlexec 9c4f6798 Y--P--- 2264 cond wait(netnorm) > 7920555 sqlexec 94ae37b0 Y--P--- 2264 cond wait(netnorm) > 7920554 sqlexec 96541a98 Y--P--- 2264 cond wait(netnorm) > 7920357 sqlexec 9911a6e8 Y--P--- 2264 cond wait(netnorm) > 7920356 sqlexec 94ae9930 Y--P--- 2264 cond wait(netnorm) > 7920350 sqlexec 94af1928 Y--P--- 2264 cond wait(netnorm) > 7920349 sqlexec 94af1f40 Y--P--- 2264 cond wait(netnorm) > 7920082 sqlexec 9c4f4308 Y--P--- 2264 cond wait(netnorm) > 7920081 sqlexec 9c4fc300 Y--P--- 2264 cond wait(netnorm) > 7920068 sqlexec 96517630 Y--P--- 2264 cond wait(netnorm) > 7920067 sqlexec 9653c548 Y--P--- 2264 cond wait(netnorm) > 7919947 sqlexec 965469d0 Y--P--- 2264 cond wait(netnorm) > 7919945 sqlexec 965369e0 Y--P--- 2264 cond wait(netnorm) > 7919774 sqlexec 9c4d9878 Y--P--- 2264 cond wait(netnorm) > 7919773 sqlexec 9c4f6db0 Y--P--- 2264 cond wait(netnorm) > 7919699 sqlexec 94b07a98 Y--P--- 2264 cond wait(netnorm) > 7919694 sqlexec 9c4f3cf0 Y--P--- 2264 cond wait(netnorm) > 7919232 sqlexec 9c4e3d00 Y--P--- 2264 cond wait(netnorm) > 7919231 sqlexec a404a618 Y--P--- 2264 cond wait(netnorm) > 7919222 sqlexec 94ae49f8 Y--P--- 2264 cond wait(netnorm) > 7919221 sqlexec a404e920 Y--P--- 2264 cond wait(netnorm) > 7918985 sqlexec a4053240 Y--P--- 2264 cond wait(netnorm) > 7918984 sqlexec 9c4f6180 Y--P--- 2264 cond wait(netnorm) > 7917690 sqlexec 9c500c20 Y--P--- 2264 cond wait(netnorm) > 7917689 sqlexec 9c4f0618 Y--P--- 2264 cond wait(netnorm) > 7917351 sqlexec 99134b60 Y--P--- 2264 cond wait(netnorm) > 7917350 sqlexec 902a7da0 Y--P--- 2264 cond wait(netnorm) > 7916911 sqlexec 9653f608 Y--P--- 2264 cond wait(netnorm) > 7916910 sqlexec 9c4de198 Y--P--- 2264 cond wait(netnorm) > 7916783 sqlexec 9652bf40 Y--P--- 2264 cond wait(netnorm) > 7916779 sqlexec 9c4e79f0 Y--P--- 2264 cond wait(netnorm) > 7916282 sqlexec 9c4feda8 Y--P--- 2264 cond wait(netnorm) > 7916281 sqlexec 9913d170 Y--P--- 2264 cond wait(netnorm) > 7916073 sqlexec 96537c28 Y--P--- 2264 cond wait(netnorm) > 7916072 sqlexec 94ae9f48 Y--P--- 2264 cond wait(netnorm) > 7916022 sqlexec 96535798 Y--P--- 2264 cond wait(netnorm) > 7916021 sqlexec 9652cb70 Y--P--- 2264 cond wait(netnorm) > 79

↪ replying to Khaled Bentebal

Art Kagel — Wed, 18 Sep 2013 12:52:15 — source: IIUG Forums & Mailing Lists

Mostly I agree with Khaled. At best you can't tell from the wait flags what's hung. Most hung sessions are either spinning CPU (so look at onstat -g spi) or waiting for a user session that's no longer there (mostly Windows clients that weren't shutdown properly, but sometimes defunct AIX clients as well). Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Sep 18, 2013 at 8:25 AM, Khaled Bentebal < khaled.bentebal@consult-ix.fr> wrote: > Hi Jack, > > The flags for your sessions are important. > > Here is the signification for your flags: > > Flags in position 1 > B - Waiting on Buffer > C - Waiting on checkpoint > G - Waiting on a logocal log buffer write > L - Waiting on a lock > S - Waiting on a mutex > T - Waiting on a transaction > Y - Waiting on condition > X - Waiting on a transaction rollback or cleanup > > All of your sessions have a Y flag which means that all of the sessions > are not doing anything but just waiting for an action from the user. > > You do not have any blocking situation or non are waiting for a > resource. None of the sessions are hanged. > > Hope that this helps. > > Cordialement, Regards, > > Khaled Bentebal > Directeur Général - ConsultiX > Président UGIF - User Group Informix France > IIUG - Board of Directors > Tél: 33 (0) 1 39 12 18 00 > Fax: 33 (0) 1 39 12 18 18 > Mobile: 33 (0) 6 07 78 41 97 > Email: khaled.bentebal@consult-ix.fr > Site Web: www.consult-ix.fr > > Le 18/09/13 07:28, JACK PAPA a écrit : > > Hi All, > > > > IDS9.4 > > OS=Solaris > > I just want to ask how can i know if a certain session already hanged? > I'm > > seeing just : > > > > 7924171 sqlexec 9651b320 Y--P--- 2264 cond wait(netnorm) > > 7924168 sqlexec a4059ff0 Y--P--- 2264 cond wait(netnorm) > > 7924166 sqlexec 991169f8 Y--P--- 2264 cond wait(netnorm) > > 7924153 sqlexec 94af49e8 Y--P--- 2264 cond wait(netnorm) > > 7924107 sqlexec 9c4e2ab8 Y--P--- 2264 cond wait(netnorm) > > 7924106 sqlexec a40450c8 Y--P--- 2264 cond wait(netnorm) > > 7923965 sqlexec 99132ce8 Y--P--- 2264 cond wait(netnorm) > > 7923964 sqlexec 99117628 Y--P--- 2264 cond wait(netnorm) > > 7923955 sqlexec 94af1310 Y--P--- 2264 cond wait(netnorm) > > 7923954 sqlexec 96538858 Y--P--- 2264 cond wait(netnorm) > > 7923953 sqlexec 90298ff8 Y--P--- 2264 cond wait(netnorm) > > 7923927 sqlexec 9912c550 Y--P--- 2264 cond wait(netnorm) > > 7923926 sqlexec 90294cf0 Y--P--- 2264 cond wait(netnorm) > > 7923921 sqlexec 94aefab0 Y--P--- 2264 cond wait(netnorm) > > 7923920 sqlexec 9c4ef9e8 Y--P--- 2264 cond wait(netnorm) > > 7923902 sqlexec 94b08ce0 Y--P--- 2264 cond wait(netnorm) > > 7923901 sqlexec 9c508600 Y--P--- 2264 cond wait(netnorm) > > 7923838 sqlexec 96533f38 Y--P--- 2264 cond wait(netnorm) > > 7923837 sqlexec 902a7788 Y--P--- 2264 cond wait(netnorm) > > 7923685 sqlexec 9c4f4920 Y--P--- 2264 cond wait(netnorm) > > 7923684 sqlexec 9c4faaa0 Y--P--- 2264 cond wait(netnorm) > > 7923677 sqlexec 90296b68 Y--P--- 2264 cond wait(netnorm) > > 7923676 sqlexec 991263d0 Y--P--- 2264 cond wait(netnorm) > > 7923621 sqlexec 9c4ed558 Y--P--- 2264 cond wait(netnorm) > > 7923615 sqlexec 96525dc0 Y--P--- 2264 cond wait(netnorm) > > 7923608 sqlexec a405f540 Y--P--- 2264 cond wait(netnorm) > > 7923607 sqlexec 94b03178 Y--P--- 2264 cond wait(netnorm) > > 7923545 sqlexec 902a52f8 Y--P--- 2264 cond wait(netnorm) > > 7923544 sqlexec 94afd610 Y--P--- 2264 cond wait(netnorm) > > 7923541 sqlexec 9c5030b0 Y--P--- 2264 cond wait(netnorm) > > 7923540 sqlexec 94b01918 Y--P--- 2264 cond wait(netnorm) > > 7923482 sqlexec a404dcf0 Y--P--- 2264 cond wait(netnorm) > > 7923481 sqlexec 94ae1f50 Y--P--- 2264 cond wait(netnorm) > > 7923449 sqlexec 9c4e5560 Y--P--- 2264 cond wait(netnorm) > > 7923448 sqlexec 99110260 Y--P--- 2264 cond wait(netnorm) > > 7923414 sqlexec 9913ace0 Y--P--- 2264 cond wait(netnorm) > > 7923413 sqlexec 94b0c3b8 Y--P--- 2264 cond wait(netnorm) > > 7923404 sqlexec 965226e8 Y--P--- 2264 cond wait(netnorm) > > 7923403 sqlexec 9913e3b8 Y--P--- 2264 cond wait(netnorm) > > 7923294 sqlexec a4048188 Y--P--- 2264 cond wait(netnorm) > > 7923293 sqlexec 9652c558 Y--P--- 2264 cond wait(netnorm) > > 7923230 sqlexec 94b086c8 Y--P--- 2264 cond wait(netnorm) > > 7923229 sqlexec 9029df30 Y--P--- 2264 cond wait(netnorm) > > 7923164 sqlexec a404a000 Y--P--- 2264 cond wait(netnorm) > > 7923163 sqlexec 9911ad00 Y--P--- 2264 cond wait(netnorm) > > 7923080 sqlexec 96540238 Y--P--- 2264 cond wait(netnorm) > > 7923079 sqlexec 9653fc20 Y--P--- 2264 cond wait(netnorm) > > 7922437 sqlexec 9912a0c0 Y--P--- 2264 cond wait(netnorm) > > 7922436 sqlexec 9651e9f8 Y--P--- 2264 cond wait(netnorm) > > 7922366 sqlexec 99115dc8 Y--P--- 2264 cond wait(netnorm) > > 7922363 sqlexec 99125db8 Y--P--- 2264 cond wait(netnorm) > > 7922054 sqlexec 9652d7a0 Y--P--- 2264 cond wait(netnorm) > > 7922052 sqlexec a4052c28 Y--P--- 2264 cond wait(netnorm) > > 7921981 sqlexec a404d0c0 Y--P--- 2264 cond wait(netnorm) > > 7921980 sqlexec 99112d08 Y--P--- 2264 cond wait(netnorm) > > 7921650 sqlexec a404f550 Y--P--- 2264 cond wait(netnorm) > > 7921649 sqlexec 965432f8 Y--P--- 2264 cond wait(netnorm) > > 7921149 sqlexec 99138850 Y--P--- 2264 cond wait(netnorm) > > 7921148 sqlexec 94b00ce8 Y--P--- 2264 cond wait(netnorm) > > 7920862 sqlexec 99121498 Y--P--- 2264 cond wait(netnorm) > > 7920861 sqlexec 9653d178 Y--P--- 2264 cond wait(netnorm) > > 7920783 sqlexec a4051ff8 Y--P--- 2264 cond wait(netnorm) > > 7920779 sqlexec 9c4e0c40 Y--P--- 2264 cond wait(netnorm) > > 7920685 sqlexec 99128860 Y--P--- 2264 cond wait(netnorm) > > 7920684 sqlexec 94b02b60 Y--P--- 2264 cond wait(netnorm) > > 7920649 sqlexec a405ca98 Y--P--- 2264 cond wait(netnorm) > > 7920648 sqlexec 9c4f6798 Y--P--- 2264 cond wait(netnorm) > > 7920555 sqlexec 94ae37b0 Y--P--- 2264 cond wait(netnorm) > > 7920554 sqlexec 96541a98 Y--P--- 2264 cond wait(netnorm) > > 7920357 sqlexec 9911a6e8 Y--P--- 2264 cond wait(netnorm) > > 7920356 sqlexec 94ae9930 Y--P--- 2264 cond wait(netnorm) > > 7920350 sqlexec 94af1928 Y--P--- 2264 cond wait(netnorm) > > 7920349 sqlexec 94af1f40 Y--P--- 2264 cond wait(netnorm) > > 7920082 sqlexec 9c4f4308 Y--P--- 2264 cond wait(netnorm) > > 7920081 sqlexec 9c4fc300 Y--P--- 2264 cond wait(netnorm) > > 7920068 sqlexec 96517630 Y--P--- 2264 cond wait(netnorm) > > 7920067 sqlexec 9653c548 Y--P--- 2264 cond wait(netnorm) > > 7919947 sqlexec 965469d0 Y--P--- 2264 cond wait(netnorm) > > 7919945 sqlexec 965369e0 Y--P--- 2264 cond wait(netnorm) > > 7919774 sqlexec 9c4d9878 Y--P--- 2264 cond wait(netnorm) > > 7919773 sqlexec 9c4f6db0 Y--P--- 2264 cond wait(netnorm) > > 7919699 sqlexec 94b07a98 Y--P--- 2264 cond wait(netnorm) > > 7919694 sqlexec 9c4f3cf0 Y--P--- 2264 cond wait(netnorm)

↪ replying to Art Kagel

RONALD OLAVIDEZ — Thu, 03 Oct 2013 09:41:17 — source: IIUG Forums & Mailing Lists

Hi Khaled, Art, Thanks for your response on this. This issue has been resolved. The problem is not on the DB level but on the application side. The application hangs after a condition was not satisfied. Again, Thank you. Ronald

How to know if a session is hanged already?

Related threads

Your privacy choices