I am running a long-running query, and it seems to be "stuck" on this operation here:
From v$session_longops, the value of "SOFAR" seems to be increasing at 2-3 blocks per minute on this sort operation. The "time remaining" is misleading as it has been stuck at 34 seconds. I don't see any other contention in the database that may be causing it.
I would appreciate some pointers as to where I could look next. I don't see any abnormal level of wait events. Thanks