This discussion is archived
1 Reply Latest reply: Apr 16, 2013 7:27 AM by 1003355 RSS

cursorsharing issue

1003355 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points