Skip to Main Content

session long ops on small table

don123Oct 12 2022

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;
962665

This post has been answered by Jonathan Lewis on Oct 13 2022
Jump to Answer
Comments
Post Details
Added on Oct 12 2022
11 comments
113 views