<div>
try the below. This query will generate kill session commands as the output and you need to just execute those commands generated in the output. <br />
<br />
&nbsp;select 'alter system kill session '|| sid || ',' || serial# || ';'<br />
&nbsp;from v$session<br />
&nbsp;where user ='SCOTT' -- i have used SCOTT for example , change it accordingly if you want some other user<br />
&nbsp;and status ='INACTIVE' -- to only get inactive sessions<br />
<br />
thanks
</div>


<div>
<div class="content wysiwyg-content">
Hello, I have installed a database with 250 sessions specified in the init file.<br />
I still see a lot of inactive sessions in the database once in a while.<br />
I would like to kill/terminate any sessions that are inactive for 2 hours. How do I achieve this?<br />
Lets say use scott has 10 sessions and only 2 of them are inactive for over 2 hours, I would like to kill only those 2.<br />
Please suggest.<br />
Thank you.
</div>
</div>


Hello, I have installed a database with 250 sessions specified in the init file.
I still see a lot of inactive sessions in the database once in a while.
I would like to kill/terminate any sessions that are inactive for 2 hours. How do I achieve this?
Lets say use scott has 10 sessions and only 2 of them are inactive for over 2 hours, I would like to kill only those 2.
Please suggest.
Thank you.

try the below. This query will generate kill session commands as the output and you need to just execute those commands generated in the output. 

 select &#39;alter system kill session &#39;|| sid || &#39;,&#39; || serial# || &#39;;&#39;
 from v$session
 where user =&#39;SCOTT&#39; -- i have used SCOTT for example , change it accordingly if you want some other user
 and status =&#39;INACTIVE&#39; -- to only get inactive sessions

thanks

Killing Inactive Oracle database sessions

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.