This content has been marked as final. Show 2 replies
You can use PROFILEs or the RESOURCE MANAGER
Is there a way we can limit the query time to force to timeout at session level?
This link to a thread in this same forum has detailed code that demonstrates this. It is too length to copy it here.
Resource plan to limit execution time
This was the original question
Can anyone guide me how should i create a resource consumer group/resource plan and assign to my user "dev" so that any query run by this user should not take more than 10 minutes for execution and should abort if execution time exceeds 10 minutes