col sql_text format a60 head "SQL Text" trunc
col error_message format a40 head "Error"
col ident format a17 head "User (Sess,@Inst)"
col name            format a35
SELECT 
   (SELECT u.username FROM all_users u WHERE u.user_id = r.user_id)||'('||session_id||',@'||instance_id||')' ident
  ,to_char( to_date(suspend_time, 'mm/dd/yy hh24:mi:ss' ), 'dd/mm hh24:mi' ) "Suspendido"
  ,to_char( to_date(resume_time, 'mm/dd/yy hh24:mi:ss' ), 'dd/mm hh24:mi' ) "Reiniciado"
  ,timeout "TimeOut"
  ,nullif(error_number||' - '|| error_msg, '0 - ' ) error_message 
  ,trim(sql_text) sql_text
FROM dba_resumable r;

hostgator