Using Resource Manager to limit SQL running time
Hi,
I'm trying to use Resource Manager in an 11.2.0.3 DB to kill certain sessions that execute SQL statements for a certain period of time. I've been successful in setting up RM to kill sessions based on I/O requests (SWITCH_IO_REQS) and I/O megabytes (SWITCH_IO_MEGABYTES) but not for SQL execution time. I tried using SWITCH_TIME in the plan directive. According to the link below that limits CPU time, but the query I need to limit is mostly I/O. In one test the SQL ran for 5 minutes with only 4 seconds of CPU time. Of course, I don't want to limit a
I'm trying to use Resource Manager in an 11.2.0.3 DB to kill certain sessions that execute SQL statements for a certain period of time. I've been successful in setting up RM to kill sessions based on I/O requests (SWITCH_IO_REQS) and I/O megabytes (SWITCH_IO_MEGABYTES) but not for SQL execution time. I tried using SWITCH_TIME in the plan directive. According to the link below that limits CPU time, but the query I need to limit is mostly I/O. In one test the SQL ran for 5 minutes with only 4 seconds of CPU time. Of course, I don't want to limit a
0