All currently active user process information in a database..!

select
p.spid os_process_Id,
'alter system kill session ' || ''''||s.sid||','||s.serial#||''' immediate;' Kill_command,
nvl (p.pname,'user process') process_name,
nvl(s.username,'BG') USERNAME,
s.SID,
s.SERIAL#,
ss.PX_SERVERS_EXECUTIONS,
s.STATUS,
s.OSUSER,
s.MACHINE,
s.blocking_session,
s.blocking_session_status,
s.state,
s.event,
s.wait_class,
round(s.WAIT_TIME_MICRO/1000000) Wait_time_inSec,
s.service_name,
s.PROGRAM,
s.module,
s.logon_time,
s.sql_id current_sql_id,
nvl(s.SQL_id,PREV_sql_id) last_exc_sql_id,
nvl2(BLOCKING_SESSION,s.sid||' Is Blocked by: '||blocking_Session,'No Block') blocking_status,
ss.sql_text,ss.sql_fulltext
from v$session s,v$process p,v$sqlarea ss
where s.paddr=p.addr
and ss.sql_id(+)=s.sql_id
and s.username not in ('SYS','SYSTEM','SYSMAN','DBSNMP')
--and s.event not like 'SQL*Net message from client'
and p.pname  is null
order by 5;

**********