Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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; |
