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
How to Migrate to different Endian Platform Using Transportable Tablespaces With RMAN (Doc ID 371556.1)How to Migrate to different Endian Platform Using Transportable Tablespaces With RMAN (Doc ID 371556.1)
Goal Starting with Oracle Database 10g, you can transpo […]