Announcement

Collapse
No announcement yet.

Index on I_TRANSACTION_NO are missing on XXX_STATUS_HISTORY tables

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Index on I_TRANSACTION_NO are missing on XXX_STATUS_HISTORY tables

    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:
    Code:
    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
    Last edited by josephliang; December 16, 2009, 04:17.
    --
    Joseph Liang
    MavenWire APAC
    http://www.mavenwire.com/
Working...
X