Wednesday, November 13, 2013

script to find lon running queries on oracle database?

select sid,
message || '(' || time_remaining || ')' "Long Ops"
from v$session_longops
where time_remaining > 600;

No comments:

Post a Comment