Database Administration (MOSC)

MOSC Banner

Progress of backend session package/procedure - oracle database 19c

edited Jan 27, 2026 10:03AM in Database Administration (MOSC) 1 commentAnswered

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.

  1. 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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center