2 Replies Latest reply: Aug 13, 2009 1:45 AM by 710379 RSS

    kill sniped sessions

      is it necessary to explicitly kill sessions marked as 'SNIPED'??

      i have set in profile limit for idle_time as 2 min.

      after that time the session is sniped,,,,but remains in GV$SESSION

      as the behaviour is -it gets removed from GV$SESSION when user tries to access again

      but users are not connecting through sqlplus,,,,

      also will this count of sniped sessions affect the total number of sessions allowed (parameter sessions)
      on instance,,,and give maximum sessions exceeded error?