The ORS GET_ALL_SHIFTS Request Is Taking Too Long To Respond Due To Missing Database Index (Doc ID 1359829.1)

Last updated on SEPTEMBER 19, 2011

Applies to:

Oracle Real-Time Scheduler - Version: 4.4.14 and later   [Release: 4.4 and later ]
Information in this document applies to any platform.

Goal

During a period of approximately 36 hours, the system was encountering very slow responses to GET_ALL_SHIFTS taking 10+ minutes in some cases. How can this be resolved?


Solution

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