Session Control with Oracle Database Resource Manager
The Oracle Database Resource Manager (DBRM) provides a wealth of functionality to control what user workloads are able to consume server and database resources. I have recently used the DBRM to provide the following functionality to the application:
- Provide the ability to limit the duration of reports that are run through the DBMS_SCHEDULER.
- Provide the ability to cancel and/or limit the duration a query submitted from the application user interface can run.