1. On-premise Customer was continuously having slowness issues within WorldServer, changing pages was slow, etc.
Oracle DBA found that there was an SQL query associated to the Notification Engine that had been executing for 15 minutes or more with a frequency of running every 10 minutes.
The SQL query from WorldServer (from the Notification Engine) for this customer that was taking a long time:
SELECT events.eventId, eventType, events.userId,
events.taskId, issueId, notificationId, taskStepId
FROM events, tasks, userprojectsDrv
WHERE eventType = 1 AND events.taskId = tasks.taskId
AND userProjectsDrv.projectId =
tasks.projectId AND userProjectsDrv.userId =
events.userId GROUP BY events.eventId,
eventType, events.userId, events.taskId, issueId, notificationId,
tasks.projectId, events.taskStepId ORDER BY events.userId,
tasks.projectId
2. A secondary issue that came up was users getting kicked out of WorldServer after the optimization of the SQL query was addressed.