You may also want to explore whether you can simply use profiles (namely idle timeout) to achieve what you want.
hth connor --- Jeremiah Wilton <[EMAIL PROTECTED]> wrote: > The last_call_et column of v$session shows the > seconds elapsed since > the session last made a database call, regardless of > the current wait > event. This is how I have always identified idle > sessions. > > And Naveen is right. The seconds_in_wait column of > v$session_wait > shows the actual time spent waiting. > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Wed, 11 Dec 2002, Naveen Nahata wrote: > > > Won't 'seconds_in_wait' show the total time waited > for the session rather > > than the current wait time? > > > > -----Original Message----- > > Denham - I'm going to make a guess here and > someone will probably correct > > me. How about > > select sid from v$session_wait where event = > 'SQL*Net message from > > client' and seconds_in_wait > 1800 > > You can join to other tables like V$SESSION to get > more information. > > > > -----Original Message----- > > Please help - I am trying to find/create a script > that will return all user > > sessions whose Idle time is greater than 30 > minutes. > > > > ie > > SELECT SID, SERIAL# > > FROM V$SESSION > > " WHERE IDLE_TIME > 30 min;" > > > > My forays into the Documentation and searches have > not been very successful. > > > > I don't really want to do this via the roles > IDLE_TIME setting, I very much > > would like to be able to query directly to the > database. > > > > Based on the information I would then make the > decision to kill the user > > process etc. > > Just in case you might be interested it is Oracle > 817 DB on Windows 2k. > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jeremiah Wilton > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
