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
《收获，不止SQL优化》 – 调优信息一键生成脚本《收获，不止SQL优化》 – 调优信息一键生成脚本
转：https://cloud.tencent.com/developer/article/1415749 梁 […]
GoldenGate replicat performance – BATCHSQL with INSERTAPPENDGoldenGate replicat performance – BATCHSQL with INSERTAPPEND
One of the nice feature of GoldenGate is BATCHSQL which […]
RMAN – Configuring Archivelog Deletion PolicyRMAN – Configuring Archivelog Deletion Policy
RMAN Deletion Policy Tips 转载：http://www.dba-oracle.com/ […]