Our DBA has identified that AAEP is executing a query against user_sessions and we are attempting to uncover why this query exists. This is the message from the DBA: "This query is executed up to 7500 times per day, and is running up 3 hours of CPU wait per business day."

This is the query being executed: SELECT *
FROM
(
SELECT usersessio0_.id as id2_,
usersessio0_.active as active2_,
usersessio0_.last_update_date as last3_2_,
usersessio0_.last_updated_by as last4_2_,
usersessio0_.device as device2_,
usersessio0_.last_access as last6_2_,
usersessio0_.token as token2_,
usersessio0_.user_id as user8_2_
FROM ivr.user_sessions usersessio0_
WHERE usersessio0_.token=:1
AND usersessio0_.active=:2
)
WHERE rownum <= :3

This query is probably being used on EP but I am not sure. Please contact Avaya Support.