RTC built in SQL query causes system down
![]()
Hi,
We are experimenting some problems with RTC 4.0. Sometimes, it becomes unstable and hangs for a while. We're using Oracle 11g. When I check the Enterprise Manager during the hang, I see that there is a query that is consuming most of the resources. This is the query:
SELECT distinct q1.ITEM_ID, q1.MODIFIED
FROM TEAMCONCERT.REPOSITORY_CHANGE_
WHERE q1.MODIFIED >= :1 and q1.JZ_ITEM_DISCRIMINATOR = :2 and (q1.EVENT_AUTHOR_ITEM_ID = :3 or q2.ITEM_ID = :4 ) order by q1.MODIFIED desc
Could you tell me what is this query related to? Could it be related to RQM reports? I don't see anything bad in the logs (Wesphere) I would really appreciate your help. Thanks |
One answer
![]()
This is a known issue.
This query is used by the change event scrubber to find the change events that have expired. Please make sure the table stats are up to date on the change events table. How many rows are in JAZZDBUSER.REPOSITR_CHNG_VNT_V |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.