set pagesize 30
set pause on
set pause 'ret..'

set linesize 140
col Username for a20
col Logon for a20
col Proc for 999999 head "Shadow|Proc|Id"
col sid for 9999
col serial# for 9999 head "Serl"
col osuser for a7
col program for a15
col process for 9999999 head "Orig|Proc|Id"
col machine for a10
col schemaname for a8
select p.spid "Proc",
       s.sid,
       s.serial#,
       s.schemaname,
       s.osuser,
       s.process,
       s.machine,
       s.terminal,
       s.program,
       --s.username,
       to_char(s.logon_time,'DD-MON-YYYY HH24:MI:SS') Logon
from v$process p,v$session s 
where s.paddr=p.addr
/

set pause off


--SQL> descr v$session
-- Name                            Null?    Type
-- ------------------------------- -------- ----
-- SADDR                                    RAW(8)
-- SID                                      NUMBER
-- SERIAL#                                  NUMBER
-- AUDSID                                   NUMBER
-- PADDR                                    RAW(8)
-- USER#                                    NUMBER
-- USERNAME                                 VARCHAR2(30)
-- COMMAND                                  NUMBER
-- TADDR                                    VARCHAR2(16)
-- LOCKWAIT                                 VARCHAR2(16)
-- STATUS                                   VARCHAR2(8)
-- SERVER                                   VARCHAR2(9)
-- SCHEMA#                                  NUMBER
-- SCHEMANAME                               VARCHAR2(30)
-- OSUSER                                   VARCHAR2(15)
-- PROCESS                                  VARCHAR2(9)
-- MACHINE                                  VARCHAR2(64)
-- TERMINAL                                 VARCHAR2(10)
-- PROGRAM                                  VARCHAR2(48)
-- TYPE                                     VARCHAR2(10)
-- SQL_ADDRESS                              RAW(8)
-- SQL_HASH_VALUE                           NUMBER
-- PREV_SQL_ADDR                            RAW(8)
-- PREV_HASH_VALUE                          NUMBER
-- MODULE                                   VARCHAR2(48)
-- MODULE_HASH                              NUMBER
-- ACTION                                   VARCHAR2(32)
-- ACTION_HASH                              NUMBER
-- CLIENT_INFO                              VARCHAR2(64)
-- FIXED_TABLE_SEQUENCE                     NUMBER
-- ROW_WAIT_OBJ#                            NUMBER
-- ROW_WAIT_FILE#                           NUMBER
-- ROW_WAIT_BLOCK#                          NUMBER
-- ROW_WAIT_ROW#                            NUMBER
-- LOGON_TIME                               DATE
-- LAST_CALL_ET                             NUMBER
--
--SQL> descr v$process
-- Name                            Null?    Type
-- ------------------------------- -------- ----
-- ADDR                                     RAW(8)
-- PID                                      NUMBER
-- SPID                                     VARCHAR2(9)
-- USERNAME                                 VARCHAR2(15)
-- SERIAL#                                  NUMBER
-- TERMINAL                                 VARCHAR2(10)
-- PROGRAM                                  VARCHAR2(48)
-- BACKGROUND                               VARCHAR2(1)
-- LATCHWAIT                                VARCHAR2(16)
-- LATCHSPIN                                VARCHAR2(16)
--
--SQL> spool off