This discussion is archived
2 Replies Latest reply: Dec 6, 2012 2:27 AM by massimino RSS

Jobs for killing a session selecting datas for more than 2hrs

massimino Newbie
Currently Being Moderated
We are running 11gR2 database.
We would need to create a job which kills all the sessions belonging to a given user which are running a select for more than two hours
Any suggestion
Thanks, massi


  • Correct Answers - 10 points
  • Helpful Answers - 5 points