col sid format 9999
col spid format 9999999999
col serial# format 9999999
col logon_time format a20
col machine format a30
col terminal format a20
set linesize 100
select p.spid,s.sid,p.pid,s.program from v$process p,v$session s where p.addr=s.addr and p.spid in ('进程号');