Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a concern with the entries in v$session_longops. I used a query to identify query running from past 25 minutes for sid=62 which is given below:

SELECT s.sid,
       ROUND(sl.elapsed_seconds/60) || ':' || MOD(sl.elapsed_seconds,60) elapsed,
       ROUND(sl.time_remaining/60) || ':' || MOD(sl.time_remaining,60) remaining,
FROM   v$session s,
       v$session_longops sl
WHERE  s.sid     = 62
AND    s.serial# = sl.serial#
AND    sl.elapsed_seconds > 25*60
and sofar<>totalwork;

it returns no rows.

But when I check with v$session_longops and v$session I have many entries for the same sid. I am using OEM 12c. Even there in sql monitoring I am able to see many queries running for more than 3 hours. I use oracle

Can anyone help me understand y is it happening? I am confused..

share|improve this question
Parallel query slaves? – Phil Mar 20 '14 at 11:33
sorry Phil ,can u please explain, as i am new to this field. – user35899 Mar 20 '14 at 11:49

you should review your query, missing s.sid = sl.sid. Besides, wher yout lokk at v$session_longops and find many rows, they all meet the other conditions - sl.elapsed_seconds > 25*60 and sofar<>totalwork ?

share|improve this answer
Hi Gustavo, Thank you for the ans. u r correct I missed the condition s.sid = sl.sid. – user35899 Mar 20 '14 at 12:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.