List User Processes

rem -----------------------------------------------------------------------
rem Filename: list_user_process.sql
rem Purpose: List User Processes
rem -----------------------------------------------------------------------

set heading off
set feedback off
set pagesize 0
set lines 200
select to_char(sysdate,'HH24:MI:ss'),pid, spid, username, program, serial# from v$process
/