Skip to Content
0
Former Member
Jan 11, 2011 at 07:38 PM

Application Server Load from Query Involving AR_SFC_ID_HISTORY

50 Views

Hello all,

It seems that our application server is performing some massive amounts of queries that is bringing the server and database to a crawl. I was wondering if anyone can point me in the right direction as to how this is happening.

The queries that seems to cause the app server and database the most problems are similar to the one below:

SELECT SUBSTR("A1"."SFC_BO",12),"A1"."SEQUENCE"

FROM "VMPRDODS"."AR_SFC_ID_HISTORY" "A1"

WHERE "A1"."SFC"='000011235620-7302' ORDER BY "A1"."SEQUENCE"

Seems to be looping through a bunch of the SFC's.

Is there a scheduled task that starts this? I can not seem to find any reference to a program or flag where this is set or any log file information. I would like to be able to understand the whole process and if this is required to run see if we could run it at night.

Thanks,

Mike Jewson