killing inactive sessions on Database
636336Feb 24 2009 — edited Feb 24 2009HI,
My DB version is 9.2.0.6 , OS is HP UX 11.11 and i am using EBS 11.5.10
i ran the following query to view no. of inactive sessions
SELECT sid,serial#,status,server
FROM v$session
WHERE username = 'APPS'
and status='INACTIVE';
there were around 300 sessions showing inactive status
can i kill those sessions
i ran another query to view sql realted to them
select a.sql_text , b.sid,b.serial#,b.LOGON_TIME,c.CPU_TIME,c.ELAPSED_TIME,c.IS_OBSOLETE
from v$sqltext a , v$session b , v$sqlarea c
where a.HASH_VALUE=b.SQL_HASH_VALUE
and b.SQL_HASH_VALUE=c.HASH_VALUE
and b.sid=14;
but iam unable to view last updated time or the last time the user worked in the session
my main problem is after 350 sessions my DB becomes really slow
and i have to bounce the DB to solve the prob
is there any other way around??