Oracle Resource Manager Implementation
This is to limit the end user from executing anything that can potentially cause the database slow down with bad queries. set serverout on size 5555 -- -- first remove an existing active plan ALTER SYSTEM SET RESOURCE_MANAGER_PLAN =''; -- -- delete any existing plan or group -- we have to create a pending area first exec dbms_resource_manager.clear_pending_area(); exec dbms_resource_manager.create_pending_area(); exec dbms_resource_manager.DELETE_PLAN ('LIMIT_EXEC_TIME'); exec dbms_resource_manager.DELETE_CONSUMER_GROUP ('GROUP_WITH_LIMITED_EXEC_TIME'); exec DBMS_RESOURCE_MANAGER.VALIDATE_PENDING_AREA; exec DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA(); begin dbms_resource_manager.create_pending_area(); -- -- we need a consumer group that maps to the desired oracle user: dbms_resource_manager.create_consumer_group( CONSUMER_GROUP=>'GROUP_WITH_LIMITED_EXEC_TIME', COMMENT=>'This...