Progress of backend session package/procedure - oracle database 19c
Hi Team,
We are running below purge command as sys user from PDB
SQL> exec DBMS_STATS.PURGE_STATS(systimestamp);
We opened different session to check the progress.
- No record in v$session_longops
SQL> SELECT SID, SERIAL#, OPNAME, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) AS "%_COMPLETE", TIME_REMAINING, ELAPSED_SECONDS
FROM V$SESSION_LONGOPS
WHERE TOTALWORK != 0 AND SOFAR != TOTALWORK; 2 3
no rows selected
SQL> set lines 300 pages 1000
alter session set nls_date_format='dd/mm/yyyy hh24:mi:ss';
select inst_id,
OPNAME,
START_TIME,
LAST_UPDATE_TIME,
round((SOFAR/TOTALWORK) * 100,2) as PCT_DONE,
round(TIME_REMAINING/60,1) as "MINUTES REMAINING"
from v$session_longops