We can use the information in the v$session_longops view to determine the working time and the remaining time of a transaction in an active session. It is also possible to have information about the related session. For RAC databases, gv$session_longops should be queried.
We can see the transaction information in the active session with a query as follows. Information on all active sessions can be obtained when the sid and serial# in the query are removed.
|
1 2 3 4 |
SQL> SELECT ROUND (v.sofar / v.totalwork * 100, 2) TAMAMLANAN, v.* FROM v$session_longops v WHERE sofar <> totalwork AND sid = 1158 AND serial# = 45853 ORDER BY target, sid; |
