Wednesday , May 29 2024

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.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *