Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

killing inactive sessions on Database

636336Feb 24 2009 — edited Feb 24 2009
HI,

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??
This post has been answered by Toni Lazarin on Feb 24 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2009
Added on Feb 24 2009
7 comments
1,195 views