4. How to identify the sessions which are Inactive for more than 1 hour in oracle database

select  sid

from   v$session

where  paddr in (select addr

                           from   v$process

                           where  background is null)

and     status=’INACTIVE’

and     last_call_et/60/60>1;