Bookshelf Home | Contents | Index | PDF |
Siebel Remote and Replication Manager Administration Guide > Implementing Replication Manager > Extracting the Regional Database > Extracting Regional Databases in ParallelParallel Database Extract is a version of the Database Extract server component that starts extractions in parallel. The Parallel Database Extract server component improves performance when Replication Manager extracts a large database for one or more regional nodes. It is an interactive component, using server infrastructure features to do data extractions in parallel for a large regional node. It uses multithreaded components to do this work more quickly than a single thread operation. Parallel Database Extract requires more hardware, but it can significantly reduce the time that Replication Manager requires to do a database extract. To extract a regional database by using the Parallel Database Extract option, you can use the administrative interface or the command line interface. Extracting Regional Databases in Parallel by Using the Administrative InterfaceYou can extract regional databases in parallel by using the administrative interface. To extract regional databases in parallel by using the administrative interface
Extracting Regional Databases in Parallel by Using the Command Line InterfaceYou can extract regional databases in parallel by using the command line interface. To extract regional databases in parallel by using the command line interface
Adjusting the Shared Pool Size for Parallel Database ExtractTo 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. Table 26 describes some examples for setting the shared pool size.
|
Siebel Remote and Replication Manager Administration Guide | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |