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:
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
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_
EVENT q1 LEFT OUTER JOIN TEAMCONCERT.REPOSITR_CHNG_VNT_
VNT_CNTRBTRS q2 ON q2.JZ_PARENT_ID = q1.ITEM_ID
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
NT_CNTRBTRS table? How about JAZZDBUSER.REPOSITORY_CHANGE_EVENT;
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