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