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
Data Guard Broker control LOG_ARCHIVE_* parametersData Guard Broker control LOG_ARCHIVE_* parameters
转：Let the Data Guard Broker control LOG_ARCHIVE_* param […]
Oracle Database 12c: PSUs vs database proactive bundle patchesOracle Database 12c: PSUs vs database proactive bundle patches
转载： by Simon Pane June 14, 2016 https://blog.pythian.co […]