Oracle Database - Inactive Sessions

Run below queries to check the Inactive sessions in Oracle database.

Login from "sys as Sysdba" option from any client tool(SQL developer)

select username, program, count(1) as "Inactive_Count" from v$session where status='INACTIVE' group by username, program;

select status, count(1) from v$session group by status;

SELECT count(sess.process), sess.status, sess.username, sess.schemaname

FROM v$session sess,

v$sql sql

WHERE sql.sql_id(+) = sess.sql_id

AND sess.type = 'USER' GROUP BY sess.status, sess.username, sess.schemaname;

SELECT sess.*, sql.sql_text

FROM v$session sess,

v$sql sql

WHERE sql.sql_id(+) = sess.sql_id

AND sess.type = 'USER';

select p.username "OSUSERNAME", p.terminal,p.program,

s.username "DBUSERNAME",s.command,s.status,

s.server,s.process,s.machine,s.port,s.terminal,s.program,

s.sid,s.serial#,p.spid FROM v$session s,v$process p

WHERE p.addr=s.paddr and s.status='INACTIVE'

order by 1,4;