RUNNING STATS DETAILS
set lines 100 pages 999
col username format a15
col message format a40
col opname for a40
col remaining format 9999
select username, opname
, to_char(start_time, 'hh24:mi:ss dd/mm/yy') started
, time_remaining remaining
, message
from v$session_longops
where upper(opname) like upper('%Gather%') AND time_remaining != 0
order by time_remaining desc
/
No comments:
Post a Comment