set pages 999;
spool rpt_wait_detail.lst;


select
  substr(to_char(dte,'MM-DD-YY HH24:MI:SS'),1,19),
  substr(server_name,1,7),
  substr(tablespace_name,1,14),
  block
from
  system.oracheck_read_waits
order by
  substr(to_char(dte,'MM-DD-YY HH24:MI:SS'),1,19);


select
  substr(to_char(dte,'MM-DD-YY HH24:MI:SS'),1,19),
  substr(server_name,1,7),
  substr(tablespace_name,1,14),
  block
from
  system.oracheck_buffer_busy_waits
order by
  substr(to_char(dte,'MM-DD-YY HH24:MI:SS'),1,19);


select
  substr(to_char(dte,'MM-DD-YY HH24:MI:SS'),1,19),
  substr(server_name,1,7),
  substr(tablespace_name,1,14),
  block
from
  system.oracheck_lock_element_waits
order by
  substr(to_char(dte,'MM-DD-YY HH24:MI:SS'),1,19);


select
  substr(to_char(dte,'MM-DD-YY HH24:MI:SS'),1,19),
  substr(server_name,1,7),
  substr(tablespace_name,1,14),
  block
from
  system.oracheck_lock_element_cleanup
order by
  substr(to_char(dte,'MM-DD-YY HH24:MI:SS'),1,19);