Oracle Realtime Scheduler Slot Booking is Not Working and Postbox Table Populated With Millions of Records
Last updated on SEPTEMBER 22, 2010
Applies to:Oracle Enterprise Real Time Scheduling - Version: 10.1.0 to 1.13.0 - Release: 10.1 to
Information in this document applies to any platform.
Users are unable to book orders through slot requests. Millions of records are in the POSTBOX table and an extra process is in the PROCESS_STATUS table where the PROC_NAME = "rts_ws.exe". The POSTBOX table cleared and began to process normally when the Oracle Realtime Scheduler (ORS) Resource Manager Web Service process (rts_ws.exe) was deleted from the PROCESS_STATUS table.
gzip -dc **/*-rsrcmgr-ws*.gz | grep SYNC_PLAN | grep recv
2. The following SQL will help identifying the problem by returning the oldest message in the POSTBOX table and show time the problem occurred.
select * from POSTBOX where msg_no=(select MIN(msg_no) from POSTBOX);
3. A dump of the PROCESS_STATUS table is required to identify the offending process.
select * from PROCESS_STATUS;
4. The scale of the problem can be seen by the number of records in the POSTBOX table.
select count(*) from POSTBOX;
5. Obtain a dump of the POSTBOX table before clearing any records.
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