Stored Procedure SSP_select_waiting_events are Being Called many Times in a Particular Day (Doc ID 1494324.1)

Last updated on JUNE 05, 2015

Applies to:

Oracle Communications ASAP - Version 7.0.2 to 7.2.0 [Release 7.0.0 to 7.2]
Information in this document applies to any platform.

Symptoms

On : ASAP 7.0.2 version

ACTUAL BEHAVIOR
---------------
Database side can see SSP_select_waiting_events being called many times in a particular Day

During that time, DBA's found out that the following query was being executed more frequently than at other times. On a particular day, the same query was executed around 500 times, while the same query has never been executed on the next day, which suggested it could have been the reason for the Slowness.

This query was running from SARM module.

SELECT SRP_ID , EVENT_TYPE , WO_ID , EVENT_UNID , ESTIMATE , MISC , REV_FLAG , EXCEPTIONS , MACH_CLLI , HOST_CLLI , REASON , CSDL_SEQ_NO , CSDL_ID , TIMEOUT_STATUS , QUEUE_TM , XACTION_TYPE , OLD_WO_STAT , NEW_WO_STAT , STATUS , EXTSYS_ID , EVENT_DTS , ROLLBACK_EXCEPTIONS FROM TBL_WO_EVENT_QUEUE WHERE SRP_ID = :B2 AND EVENT_UNID > :B1 AND EVENT_STATUS = 301 ORDER BY EVENT_UNID

Checked the database and following query is executed from Stored Procedure "SSP_SELECT_WAITING_EVENTS" .

Now we need to know in what cases will the SARM execute this Stored Procedure and why multiple times, even when the SARM was not recycled?

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms