About Oracle resource consumer groups

Note: Use the information in this topic only if you experience slow policy queries. If you do not experience slow policy queries, you do not need to define a resource consumer group for policy queries.

Oracle provides resource plans and consumer groups to handle resources in the database. One useful feature is to cancel a query based on the execution time. You can configure PolicyCenter to switch to a resource consumer group that you define to perform policy searches. You can set this resource consumer group to have a time limit and cancel SQL operations for policy searches that exceed the time limit.

PolicyCenter saves the initial resource consumer group that it detects during server start up and reverts to that group following the policy query.

The requirements for using Oracle resource consumer groups for policy queries are:

The db-resource-mgr-cancel-sql attribute is set on element <oracle-settings> in database-config.xml to a resource consumer group defined in Oracle, for example:
```
<database name="PolicyCenterDatabase" dbtype="oracle">
   ...
  <oracle-settings db-resource-mgr-cancel-sql="" />
   ...
</database>
```
The Oracle resource manager plan is set at the system level.
User pcUser has privileges to switch between the two resource groups.

PolicyCenter checks these conditions at server start up.