Query to find Long running Process Name.


       

select s.sid,o.object_name,TO_CHAR(logon_time,'YYYY-MM-DD HH24:MI:SS') "LOGON", S.USERNAME, S.OSUSER,S.SQL_ID,'alter system kill session ''' || s.sid || ',' || s.serial# || ''' immediate;' from v$session s,dba_objects o where plsql_entry_object_id=o.object_id ;

Comments