select DISTINCT s.sid,s. SERIAL#, event, p1text, p1, p2text, p2, 
                p3text, p3,
                wait_time, seconds_in_wait, state, 
                osuser, program,client_info, s.MODULE, 
                sql_text
  from v$session s
  join v$sql q ON q.hash_value = s.sql_hash_value
 where event not in ('SQL*Net message from client', 
                     'SQL*Net message to client', 
                     'jobq slave wait')
  AND  event not like 'PX Deq Credit%';