How to Check Inactive Sessions Detail in Oracle Database

DBA scripts to query inactive sessions detail in Oracle Database:

SQL > SELECT S.SID,S.SERIAL#,P.PID "ORAPID",P.SPID "SPID",S.USERNAME,S.STATUS,S.LAST_cALL_ET/60,S.OSUSER,S.MACHINE,s.program,s.ACTION
   FROM gV$SESSION S,gV$PROCESS P
   WHERE S.PADDR=P.ADDR
   AND S.USERNAME IS NOT NULL
   AND S.STATUS='INACTIVE'
   ORDER BY S.USERNAME;