Siebel Performance Tuning Guide > Tuning Siebel Remote for Performance > Tuning Siebel Remote Server Components >
Increasing Throughput for the Database Extract and Parallel Database Extract Components
The following list describes tips to improve the throughput for the Database Extract and Parallel Database Extract components:
- Run multiple instances
You can increase throughput by running multiple concurrent instances of the Database Extract component. Each instance of the Database Extract component requires a temporary table. This table is called S_DOCK_INITM_N where N equals the value of the parameter TS Table Number (alias TSTableNum). TS Table Number specifies the number of the temporary table that serves the Database Extract component. For example, if TS Table Number equals 1, then temporary table 1 (S_DOCK_INITM_1) serves the instance of the Database Extract component that is currently executing.
By default, 48 temporary tables are available for use. If you require additional tables, you create them using Siebel Tools.
The recommended number of temporary tables to use depends on the database platform in use. For example:
- Microsoft SQL Server and IBM DB2 Universal Database
Use one temporary table for each instance of the Database Extract component that you execute. For example, if you execute 11 instances of the Database Extract component, then use 11 temporary tables.
- Oracle Enterprise Server
The number of temporary tables that you use depends on the size of the shared pool that this database server can access. If the size of the shared pool is less than 300 MB, it is recommended that you use one temporary table and execute one instance of the Database Extract component. If the size of the shared pool is greater than 600 MB, then using one temporary table for each instance of the Database Extract component may increase throughput.
- Transaction Router component
Stop the Transaction Router component if running multiple instances of Database Extract or Parallel Database component in order to avoid table locking.
- Extract lists of users simultaneously
Separate users to be extracted into groups of 50 - 100 users per list and extract these lists of users simultaneously using the Database Extract and Parallel Database Extract components. These components extract the Enterprise visibility data for all users in the list once.
- Set the Truncate TS table parameter to True
Setting this parameter (alias TruncateTSTable) to True can improve performance as deleting from S_DOCK_INITM_N is usually logged and can take a long time.
- Defragment tables
Defragment tables to which you intend to extract data and S_DOCK_INITM_N tables.
For more information about the components and parameters described previously, see Siebel Remote and Replication Manager Administration Guide. For more information about performance issues for the Database Extract component, see Troubleshooting Steps 15 on Siebel SupportWeb.
|