[josephliang]

Bug 8360003: ADD INDEX ON I_TRANSACTION_NO ON SS_STATUS_HISTORY - fixed by 5.5 CU5 RU5

Bug 8418657: FP 5.5.05.05-6.0:ADD INDEX ON I_TRANSACTION_NO ON SS_STATUS_HISTORY - fixed by 6.0.2

Bug 8518895: ORDER RELEASE EVENTS QUEUE BACKLOG DUE TO LACK OF INDEX - REQUEST TO ADD INDEX - fixed by 5.5 CU6

Missing indexes in Event tables may cause performance downgrade. If you can not upgrade to fixed version, you can manually add the following indexes:

CREATE INDEX "GLOGOWNER"."IX_SSH_I_TRANSNO_GID" 
ON "GLOGOWNER"."SS_STATUS_HISTORY"
("I_TRANSACTION_NO")  TABLESPACE "INDX" ;
 
CREATE INDEX "GLOGOWNER"."IX_ORSH_I_TRANSNO_GID" 
ON "GLOGOWNER"."ORDER_RELEASE_STATUS_HISTORY"
("I_TRANSACTION_NO")  TABLESPACE "INDX" ;

Reference:
Metalink Note ID 797844.1 - Shipment Events Threads are Backed Up Due to Lack of Index on SS_STATUS_HISTORY
Metalink Note ID 830896.1 - Processing a Batch of Order Release Event Messages Causes Orsevents Queue to be Backlogged