####################################### # sid_spid_sql.sql ####################################### set lines 300 pages 300 spool sql column program format a20 column USERNAME format a12 select s.sid, s.serial#, s.username, p.spid " Os pid", substr(s.machine,11,4) machine, a.sql_text from v$session s, v$sqlarea a, v$process p where a.address = s.sql_address and s.paddr=p.addr order by 1 / ####################################### RAC - gv$ views ####################################### set lines 300 pages 300 spool sql column program format a20 column USERNAME format a12 select s.inst_id, s.sid, s.serial#, s.username, p.spid " Os pid", substr(s.machine,11,4) machine, a.sql_text from v$session s, v$sqlarea a, v$process p where a.address = s.sql_address and s.paddr=p.addr order by 1 / |