set linesize 320
col MESSAGE format a80
col opname for a20
col username for a20
set pagesize 1000
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select sysdate from dual;
select opname,TIME_REMAINING REMAIN,ELAPSED_SECONDS ELAPSE,MESSAGE,SQL_ID,sid,username
from v$session_longops where TIME_REMAINING >0;
col MESSAGE format a80
col opname for a20
col username for a20
set pagesize 1000
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select sysdate from dual;
select opname,TIME_REMAINING REMAIN,ELAPSED_SECONDS ELAPSE,MESSAGE,SQL_ID,sid,username
from v$session_longops where TIME_REMAINING >0;