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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------