2 Replies Latest reply: Dec 6, 2012 4:27 AM by massimino RSS

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

    massimino
      Hi,
      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