select SQL_ID, OPNAME, SOFAR, TOTALWORK, START_TIME, ELAPSED_SECONDS FROM VSESSION_LONGOPS WHERE USERNAME = '<USER_NAME>' AND TIME_REMAINING>0;
---------------- ------------ ------- -------- -------- -----
4drkj065d8r35 Table Scan 739658 1989527 12-MAY-21 30492
select sql_text from gvsql where sql_id='4drkj065d8r35';
Check long running DML progress
Categories:
Related Post
Oracle GoldenGate: Handle Collision Parameter and its usageOracle GoldenGate: Handle Collision Parameter and its usage
July 29, 2018 by Atul Kumar from: https://k21academy.co […]
Oracle home preferred locations for 19cOracle home preferred locations for 19c
I have used for GRID_HOME and DB_HOME the following loc […]
hint to enforce FULL SCAN with direct path readhint to enforce FULL SCAN with direct path read
from https://community.oracle.com/tech/apps-infra/discu […]