Script to identify Oracle long running queries

Below query can be used to check what are the  Script to identify Oracle long running queries in database .

set linesize 100
col opname format a20
col target format a15
col units format a10
col time_remaining format 99990 heading Remaining[s]
col bps format 9990.99 heading [Units/s]
col PERCENTAGE_COMPLETE format 90.99 heading “complete[%]”
select sid,
opname,
target,
sofar,
totalwork,
units,
(totalwork-sofar)/time_remaining bps,
time_remaining,
sofar/totalwork*100 PERCENTAGE_COMPLETE
from v$session_longops
where time_remaining > 0

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.