Hi,
This is the actual query that hoses our production system. T2068 = Help Desk form SELECT * FROM ( SELECT T2068.C1, C1000000161, C1000000000, C303497300, C1000000164, C7, C1000000218, C1000005261, C1000000217, C1000003009, C1000000018, C1000000019, C1000000150, C179, C1000000422, C1000000715, C4, C1000000079, C1000000162, C1000002613, C1000005785, C1000005791, C1000000560, C1000000151, C1000000099, C1000000056, C1000000001, C1000000080, C1000000020, C1000000163, C3, C303497400 FROM T2068 WHERE ((T2068.C7 < :"SYS_B_00") AND (:"SYS_B_01" = :"SYS_B_02") AND (:"SYS_B_03" = :"SYS_B_04") AND ((T2068.C60900 LIKE :"SYS_B_05") OR (T2068.C60900 LIKE :"SYS_B_06") OR (T2068.C60900 LIKE :"SYS_B_07") OR (T2068.C60900 LIKE :"SYS_B_08") OR (T2068.C60900 LIKE :"SYS_B_09") OR (T2068.C60900 LIKE :"SYS_B_10") OR (T2068.C60900 LIKE :"SYS_B_11") OR (T2068.C60900 LIKE :"SYS_B_12") OR (T2068.C60900 LIKE :"SYS_B_13") OR (T2068.C60900 LIKE :"SYS_B_14") OR (T2068.C60900 LIKE :"SYS_B_15") OR (T2068.C60900 LIKE :"SYS_B_16") OR (T2068.C60900 LIKE :"SYS_B_17") OR (T2068.C60900 LIKE :"SYS_B_18") OR (T2068.C60900 LIKE :"SYS_B_19") OR (T2068.C60900 LIKE :"SYS_B_20") OR (T2068.C60900 LIKE :"SYS_B_21") OR (T2068.C60900 LIKE :"SYS_B_22") OR (T2068.C60900 LIKE :"SYS_B_23") OR (T2068.C60900 LIKE :"SYS_B_24") OR (T2068.C60900 LIKE :"SYS_B_25 ") OR (T2068.C60900 LIKE :"SYS_B_26") OR (T2068.C60900 LIKE :"SYS_B_27") OR (T2068.C60900 LIKE :"SYS_B_28") OR (T2068.C60900 LIKE :"SYS_B_29") OR (T2068.C60900 LIKE :"SYS_B_30") OR (T2068.C60900 LIKE :"SYS_B_31") OR (T2068.C60900 LIKE :"SYS_B_32") OR (T2068.C60900 LIKE :"SYS_B_33") OR (T2068.C60900 LIKE :"SYS_B_34") OR (T2068.C60900 LIKE :"SYS_B_35") OR (T2068.C60900 LIKE :"SYS_B_36") OR (T2068.C60900 LIKE :"SYS_B_37") OR (T2068.C60900 LIKE :"SYS_B_38") OR (T2068.C60900 LIKE :"SYS_B_39") OR (T2068.C60900 LIKE :"SYS_B_40") OR (T2068.C60900 LIKE :"SYS_B_41") OR (T2068.C112 LIKE :"SYS_B_42") OR (T2068.C112 LIKE :"SYS_B_43") OR (T2068.C112 LIKE :"SYS_B_44") OR (T2068.C112 LIKE :"SYS_B_45") OR (T2068.C112 LIKE :"SYS_B_46") OR (T2068.C112 LIKE :"SYS_B_47") OR (T2068.C112 LIKE :"SYS_B_48") OR (T2068.C112 LIKE :"SYS_B_49") OR (T2068.C112 LIKE :"SYS_B_50") OR (T2068.C112 LIKE :"SYS_B_51") OR (T2068.C112 LIKE :"SYS_B_52") OR (T2068.C112 LIKE :"SYS_B_53") OR (T2068.C112 LIKE :"SYS_B_54") OR (T2068.C112 LIKE :"SYS_B_55") OR (T2068.C112 LIKE :"SYS_B_56") OR (T2068.C112 LIKE :"SYS_B_57") OR (T2068.C112 LIKE :"SYS_B_58") OR (T2068.C112 LIKE :"SYS_B_59" ) OR (T2068.C112 LIKE :"SYS_B_60") OR (T2068.C112 LIKE :"SYS_B_61") OR (T2068.C112 LIKE :"SYS_B_62") OR (T2068.C112 LIKE :"SYS_B_63") OR (T2068.C112 LIKE :"SYS_B_64") OR (T2068.C112 LIKE :"SYS_B_65") OR (T2068.C112 LIKE :"SYS_B_66") OR (T2068.C112 LIKE :"SYS_B_67") OR (T2068.C112 LIKE :"SYS_B_68") OR (T2068.C112 LIKE :"SYS_B_69") OR (T2068.C112 LIKE :"SYS_B_70") OR (T2068.C112 LIKE :"SYS_B_71") OR (T2068.C112 LIKE :"SYS_B_72") OR (T2068.C112 LIKE :"SYS_B_73") OR (T2068.C112 LIKE :"SYS_B_74") OR (T2068.C112 LIKE :"SYS_B_75") OR (T2068.C112 LIKE :"SYS_B_76") OR (T2068.C112 LIKE :"SYS_B_77") OR (T2068.C112 LIKE :"SYS_B_78"))) ORDER BY C1000000161 DESC, :"SYS_B_79" ASC ) WHERE ROWNUM <= :"SYS_B_80" From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Monday, February 04, 2013 4:52 PM To: arslist@ARSLIST.ORG Subject: Re: Critical: Server Hung ** Kathy, how many rows are in the table referenced by the console? I've seen this happen in some versions where the form doesn't get cleared, and the SQL queries bog the system down. Rick On Mon, Feb 4, 2013 at 1:50 PM, Kathy Morris <kathymorris...@aol.com> wrote: ** Hi, AR System 7.6.03 ITSM 7.6.04 SP1. The incident management console hangs and hoses the system when users access the Incident Management Overview console. My understanding is that thru a row-level access query, users see the incidents for the group they are member of. If users are a part of many groups, however this can cause problems. How can we prevent this query from crashing the system to the point where our database is unresponsive. Are any others experiencing this performance issue? Any ideas on what we can do to get our system to a stable state? _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
