SELECT  
                 s.serial#			SERIAL, 
                 s.username			DBUSER ,
        	 s.osuser			OSUSER, 
        	 s.module			MODULE, 
        	 s.terminal			TERMINAL,
                 s.program 			S_PROGRAMM, 
        	 p.program 			P_PROGRAMM,
                 to_char(s.logon_time,'dd.mm.yyyy hh24:mi:ss') LOGON, 
        	 lockwait			LOCKWAIT,
                 si.physical_reads	PHYS_READ, 
        	 si.block_gets		BLOCK_GETS,
                 si.consistent_gets	CONS_GETS,
                 si.block_changes	BLOCK_CHANGES,
                 si.consistent_changes CONST_CHANGES, 
        	 s.process			PROCESS,
                 p.spid				SPID, 
        	 p.pid				PID, 
        	 si.sid				SID, 
        	 s.sql_address		SQL_ADRESS,
                 s.sql_hash_value	SQL_HASH_VALUE, 
        	 s.action			ACTION
            FROM v$session s, v$process p, sys.v$sess_io si
           WHERE s.paddr = p.addr(+)
             AND si.sid(+) = s.sid
             AND (s.username IS NOT NULL)
             AND (NVL (s.osuser, 'x') <> 'SYSTEM')
             AND (s.TYPE <> 'BACKGROUND')[color=purple][/color] 8o 
        	AND s.username='CRES2BATCH'
        ORDER BY s.logon_time desc