Site icon Database Tutorials

Find How Much Time Left For Query Completion Oracle

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.

Exit mobile version