Adjusting the Shared Pool Size for Parallel Database Extract

To meet the cache requirements for a parallel database extract, the init.ora file contains a parameter named SHARED_POOL_SIZE that you can adjust. The number of temporary tables that you use depends on the size of the shared pool that the Siebel 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 run 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 might increase throughput.

The following table describes some examples for setting the shared pool size.

Number of Databases Extracted in Parallel	Table Usage
48	One database extract assigned to each S_DOCK_INITM_X table.
100	One database extract assigned to each S_DOCK_INITM_X table.
200	Two database extracts assigned to each S_DOCK_INITM_X table.

For more about:

• Sizing the shared pool, see Siebel Performance Tuning Guide.

• The init.ora file and the SHARED_POOL_SIZE parameter, see the Siebel Installation Guide.