1. Performance Tuning Guide
  2. Slow-Running Queries

Slow-Running Queries

If you diagnose the root cause of the Transaction Router performance issue to be slow-running queries, then consult your database administrator to determine the following:

  • All indexes are present and valid on the tables involved in the poor-performing queries. To determine if all indexes are valid and present, see Siebel Data Model Reference on My Oracle Support (Article ID 2285310.1).

  • Check whether the tables and indexes involved in the poor-performing queries require defragmentation.