oracle list of long running queries

VasteMonde answered on February 17, 2021 Popularity 5/10 Helpfulness 7/10

answer oracle list of long running queries

Comment

SELECT SID, to_char(START_TIME, 'hh24:mi:ss') STIME, MESSAGE, (SOFAR / TOTALWORK) * 100 PERCENT
FROM V$SESSION_LONGOPS
WHERE SOFAR / TOTALWORK < 1;

Popularity 5/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: list oracle sql

Link to this answer
Share Copy Link

Contributed on Feb 17 2021

VasteMonde

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.