18_Pct_Create_Object.sql
set lines 100
set pages 1000
col OPNAME format a25
col PCT format a7
col TARGET format a30
col MINUTES format 999.99
select round((sofar/totalwork)*100,2) ||'%' pct,
opname, target,
round(time_remaining/60, 2) minutes
from v$session_longops
where round((sofar/totalwork)*100,2) != '100'
/
Nenhum comentário:
Postar um comentário