long running job

From: Kommareddy, Srinivas (MED, Wissen Infotech) <Srinivas.Kommareddy_at_med.ge.com>
Date: Tue, 17 Feb 2004 02:45:31 -0600
Message-ID: <1C9727B12F498543A43CBB988F30515C02349A9D@uswaumsx14medge.med.ge.com>

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    

---

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 - 02:45:31 CST