I am not too familiar with how to audit sessions running my DB. Should I be concerned about OLD sessions? Or sessions that I do not know what they are doing? Any advice is appreciated. The following is an example. It's been running thru sqlplus on the server side since 11/03/2000 (sorry for how it looks on this forum):
Strange. I guess if they are inactive since a long time, you could kill the processes. Another option would be to bounce the db in order to shutdown the processes cleanly.
12-15-2000, 12:33 PM
denevge
Maybe you can use the next view to determine if you can cancel a certain session.(NM : nusmber of minutes )
It returns the sid of all the sessions that have been inactive for NM*60 seconds.
select v.spid
from v$session s,v$session_wait w,v$process v
where
s.sid = w.sid and
v.pid = s.sid and
seconds_in_wait > &NM * 60