Creating Partitions for BP Tables
Creating partitions for large business process (BP) tables, such as those whose number of rows exceeds 500 thousand, improves query performance. As explained in the Oracle database documentation, partitioning a database creates smaller, more manageable pieces, while not impacting the structured query language (SQL) queries. Because a large data set might cause performance issues when the system is loading BP logs, sheets, grids, pickers, and so on, you can use the Table Partitions option under Data Structure Setup to create a partition for specific BP tables that have large data sets, such as those that contain in excess of 500 thousand records.
Notes:
- Partitioning is irreversible and might affect system performance while it is in process; Oracle recommends that you run partitioning during off-peak hours for your organization.
- At this time, only the tables for Simple and Line Item BPs defined at the project/shell level are available for partitioning; single-record BPs and company-level BPs are excluded.
- The performance improvement achieved by implementing this feature depends on your environment and how Unifier is implemented. In particular, the design of BPs and their components affects the performance of subsequent searches.
Step 1: Verify that your database meets prerequisites. To use this feature, make sure that your Oracle database meets the following prerequisites. It must:
- Use Oracle Database Enterprise Edition.
- Have partitioning enabled. By default, partitioning is enabled for Oracle Cloud-based Unifier environments. For more information about partitioning an Oracle database, go to the Oracle Database Documentation site, search for partitioning, and select your database version.
Step 2: Set permissions for creating, updating, and viewing table partitions. For more information, see Granting Permissions for Table Partitions.
Step 3: Create or update partitions. For more information, see Creating or Updating Table Partitions.
Step 4: Monitor partition status and history. For more information, see Monitoring Table Partitions.
In This Section
Granting Permissions for Table Partitions
Creating or Updating Table Partitions
Last Published Tuesday, April 8, 2025