Use this one :

SELECT s.SID, s.osuser, s.username username, s.schemaname,
s.machine, P.spid, s.logon_time,
(ROUND (TO_NUMBER (SYSDATE - logon_time) * 24 *
60
* 60
)
) elapsed_sec,
l.sql_text
FROM v$session s, v$sqltext_with_newlines l,
v$process P
WHERE s.status = 'ACTIVE'
AND s.schemaname <> 'SYS'
AND (ROUND (TO_NUMBER (SYSDATE - logon_time) * 24 *
60
* 60
)
) > :val
AND s.sql_address = l.address
AND s.paddr = P.addr
ORDER BY s.SID, piece

-----Original Message-----
From: Ranganath H M
[mailto:oracledba-ezmlmshield-x83211393.[Email address protected]
Sent: 29 March 2007 12:31
To: LazyDBA Discussion
Subject: Finding long running jobs

Hi all,
I am not able to find the long running jobs running in my database by
using these views
DBA_JOBS
USER_JOBS
V$SESSION_LONGOPS

Is there any way to find apart from these?

Thanks,
Ranga


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page