Home › Siebel › Articles

table monitoring

There are different types of tables in Siebel. Conventional Siebel tables contain data entered by end users or feeds from external systems. All Siebel tables include the following system columns:

  • CREATED - creation date and time
  • CREATED_BY - who created the record
  • LAST_UPD - timestamp of last modification
  • LAST_UPD_BY - who performed last modification

Standard SQL may be used to determine historical growth rates: 

SQL> select count(*), trunc(created, 'MM')
from siebel.s_contact
group by trunc(created, 'MM');

Some tables are internal tables used by server components. The following tables are volatile tables containing records that are queued for processing by a server component:

  • S_ESCL_REQ - workflow requests
  • S_DOCK_TXN_LOG - transactions to be routed to mobile web clients

If the number of records in these tables is unusually high or continuously increasing, it may indicate a backlog or an underlying performance issue.