Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: long running job
This script might help you to see the rollback movement :
select e.sid, e.serial# ,substr(a.os_user_name,1,15) "OS User", substr(b.object_type,1,8) "Type"
, substr(b.object_name,1,20) "Object Name"
and a.xidusn = c.segment_id and a.xidusn = d.xidusn and a.xidslot = d.xidslot and d.addr = e.taddr
Regards
Rafiq
From: "Kommareddy, Srinivas (MED, Wissen Infotech)"
<Srinivas.Kommareddy_at_med.ge.com>
Reply-To: oracle-l_at_freelists.org
To: oracle-l_at_freelists.org
Subject: long running job
Date: Tue, 17 Feb 2004 02:45:31 -0600
Hi All,
How to find out the long running job.
I guess, we can select the login time from v$session whose status = 'ACTIVE'; My co-dba said that , he killed a long running job and the jobis currently rolling back and the rollback will take lot of time (may be approximately 1-2 hrs) how to find out this.
This could be checked from :
Select CONSISTENT_GETS from v$sess_io where sid=sid; ( - the output should
be keep increasing... )
Is the above statements are correct to check the login running job and the huge rollback ?
Thanks and Regards,
Srinivas
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- _________________________________________________________________ Find and compare great deals on Broadband access at the MSN High-Speed Marketplace. http://click.atdmt.com/AVE/go/onm00200360ave/direct/01/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Feb 17 2004 - 08:22:46 CST
![]() |
![]() |