How can I use Oracle partitioning?

Using 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.

For more information about the configureDb command, see Database configuration - configureDB script.