SELECT SID, SERIAL#,MODULE, STATUS FROM V$SESSION S WHERE S.USERNAME IS NOT NULL AND UPPER(S.PROGRAM) IN ( 'W3WP.EXE')ĪND S.LAST_CALL_ET >= 60*60*24 AND S.STATUS = 'INACTIVE' ORDER BY SID DESC Session is not used in last 24 hours(1 days) STATUS is currently INACTIVE, then the value represents the elapsed time in seconds since the session has become inactive. STATUS is ACTIVE, then the value represents the elapsed time in seconds since the session has become active. LAST_CALL_ET : its consider value in seconds, means not run any query from last 24 hours if we value greater than 60*60*24 Select username, UPPER(program), logon_time,įloor(last_call_et / 60) "Minutes since active", status
check inactive session time with minute since last active WHERE username IS NOT NULL and status='INACTIVE'-and module like 'Host%'Ĭheck Inactive Session which is not used from 24 hours or more. SELECT to_char(logon_time,'DD/MM HH24:MI:SS') logontime, WHERE username IS NOT NULL and status='ACTIVE'-and module like 'Host%' Username,terminal,osuser,status,sid,serial#,program,audsid Username,terminal,osuser,status,sid,serial#,programįind the session and process id for particular session:Ĭurrently Active session with detailed SQL Queries on Database:Ĭurrently Active Session on Database with login time SELECT to_char(logon_time,'DD/MM/YYYY HH24:MI:SS') logontime,
#Oracle kill session that has connections how to#
How many session is inactive?, how much time a session is in inactive state? and how to kill the inactive session? such as How many session is active?, How many session running from specific module? You are able to get the info about the session and get details about session.
0 kommentar(er)
