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:

Step 1: Verify that your database meets prerequisites. To use this feature, make sure that your Oracle database meets the following prerequisites. It must:

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

Monitoring Table Partitions



Last Published Tuesday, April 8, 2025