Thanks for the question, Kai Yang.
Asked: September 13, 2016 - 3:47 pm UTC
Last updated: September 14, 2016 - 1:18 am UTC
Version: 11g
Viewed 1000+ times
You Asked
Why the query session showing inactive but the long operation still in progress and running ?
and Connor said...
That's not normally typical but its possible. A common example lots of single row fetches. All the time is spent delivering the row, and the database time is tiny, so you never *see* the session being marked as status=active.
Check the SQL_ID / PREV_SQL_ID columns in V$SESSION, and then check V$SQL and V$SQLSTATS for those entries, and see if they are still progressing.
Hope this helps.
Is this answer out of date? If it is, please let us know via a Comment