It's all about the answers!

Ask a question

RTC built in SQL query causes system down


Leonardo Marzo (24964852) | asked Apr 17 '13, 4:37 p.m.
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_ 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



permanent link
Piotr Aniola (3.7k11738) | answered Apr 18 '13, 6:01 a.m.
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;

Your answer


Register or to post 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.