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
Create Role and grant to userCreate Role and grant to user
Traget: grant user abc with read only access to all the […]
How To Enable The New Unified Auditing In 12c ? (Doc ID 1567006.1)How To Enable The New Unified Auditing In 12c ? (Doc ID 1567006.1)
GOAL A newly created 12c database might have Unified Au […]
Oracle ASMM (Automatic Shared Memory Management)Oracle ASMM (Automatic Shared Memory Management)
1.ASMM简介 ASMM是Oracle 10g提供内存管理方式。使用ASMM，不再需要手工设置shared […]