We are using Oracle 12.2 database standard edition.
select opname, target, sofar, totalwork, units, start_time, last_update_time, time_remaining,
elapsed_seconds,message, sql_plan_operation, sql_plan_options
from v$session_longops where sid=12 and time_remaining!=0;
Table Scan, XXXXXXXXX, 158204, 204924, Blocks, 11-OCT-22, 12-OCT-22, 27870, 94373, Table Scan: XXXXXXXXX: 158204 out of 204924 Blocks done, TABLE ACCESS, FULL
The session is running for the last several hours, the table is not big, less than million records, how this could be resolved ?
select count(*) from XXXXXXXXX;