1 Reply Latest reply: Apr 16, 2013 9:36 AM by François Degrelle RSS

    cursorsharing issue

    1003355
      Hello ,

      In my database one query is system generated and repeatedly executes all the time when ever a user logins to the application it checks the user privileges. So this query is constantly executes all the time.

      We had an issue from the database that this query is causing concurrency due to pin s wait on x. Application is going down due to that.

      child cursor is set to 25 and cursor_sharing = Force.

      SELECT Permissions
      FROM DTreeACL
      WHERE
      (
      DataID=:A1
      )
      AND
      (
      ACLType =:"SYS_B_00"
      OR ACLType=:"SYS_B_01"
      )
      AND
      (
      RightID IN (-:"SYS_B_02",:"SYS_B_03",:"SYS_B_04",:"SYS_B_05",:"SYS_B_06",:"SYS_B_07",:"SYS_B_08",:"SYS_B_09",:"SYS_B_10",:"SYS_B_11",:"SYS_B_12",:"SYS_B_13",:"SYS_B_14",:"SYS_B_15",:"SYS_B_16",:"SYS_B_17",:"SYS_B_18",:"SYS_B_19",:"SYS_B_20",:"SYS_B_21",:"SYS_B_22",:"SYS_B_23",:"SYS_B_24",:"SYS_B_25",:"SYS_B_26",:"SYS_B_27",:"SYS_B_28",:"SYS_B_29",:"SYS_B_30",:"SYS_B_31",:"SYS_B_32",:"SYS_B_33",:"SYS_B_34",:"SYS_B_35",:"SYS_B_36",:"SYS_B_37",:"SYS_B_38",:"SYS_B_39",:"SYS_B_40",:"SYS_B_41",:"SYS_B_42",:"SYS_B_43",:"SYS_B_44",:"SYS_B_45",:"SYS_B_46",:"SYS_B_47",:"SYS_B_48",:"SYS_B_49",:"SYS_B_50",:"SYS_B_51",:"SYS_B_52",:"SYS_B_53",:"SYS_B_54",:"SYS_B_55",:"SYS_B_56",:"SYS_B_57",:"SYS_B_58",:"SYS_B_59",:"SYS_B_60",:"SYS_B_61",:"SYS_B_62",:"SYS_B_63",:"SYS_B_64",:"SYS_B_65",:"SYS_B_66",:"SYS_B_67",:"SYS_B_68",:"SYS_B_69",:"SYS_B_70",:"SYS_B_71",:"SYS_B_72",:"SYS_B_73",:"SYS_B_74",:"SYS_B_75",:"SYS_B_76",:"SYS_B_77",:"SYS_B_78")
      )

      we have identified that the query is having Bindmismatch, Incomp_Ltrl_mismatch and User_Bindpeek_mismatch.

      Any suggetions how to resolve the issue.