How can I use Oracle partitioning?

Partitioning is a powerful functionality that enables tables, indexes, and index-organized tables to be subdivided into smaller pieces, allowing these database objects to be managed and accessed at a finer level of granularity. Moreover, the Oracle partitioning feature can improve the performance of the auditing feature and event-driven workload automation. This functionality improves rule management performance, in particular the following queries:

• event_rule_instance
• action_run
• operator_messages

If partitioning is already enabled in your Oracle database, proceed as follows:

1. Browse to the folder containing the configureDb command. The command is located in the following path, depending on the component for which you are installing:

   master domain manager

   image_location/TWS/interp_name

   Dynamic Workload Console

   image_location

2. When launching the configureDb command, as explained in Installing the master domain manager and backup master domain manager and Installing the Dynamic Workload Console servers, modify the following parameter as necessary:

   --usePartitioning

   Only applies when installing the master domain manager. Set to true if you want to use the Oracle partitioning feature, otherwise set it to false. This parameter is optional. The default value is true.