Ryan, Couple of thoughts: - add "sofar < totalwork" to your V$SESSION_LONGOPS query - Not all operations report progress in V$SESSION_LONGOPS. In general = FTS, FIS, Index creation, index rebuild, are the types of things that = update V$SESSION_LONGOPS. -Mark -----Original Message----- From: ryan.gaffuri@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx] Sent: Monday, February 09, 2004 5:20 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: question about v$session_longops Followup. I know what is running and the sid by using the following = query=20 SELECT sql_text, saddr, start_scnb,sid =20 FROM v$sqlarea,v$session, v$transaction =20 WHERE v$sqlarea.address =3D v$session.sql_address AND v$transaction.ses_addr =3Dv$session.saddr =20 ORDER BY start_scnb =20 However, when i check v$session_longops for the sid in question, a = transaction that has completed shows up? Also, there are several = transactions in v$session_longops that I know have completed. Such as = create indexes statements(since I see them in the dba_indexes). >=20 > From: <ryan.gaffuri@xxxxxxx> > Date: 2004/02/09 Mon PM 05:03:47 EST > To: oracle-l@xxxxxxxxxxxxx > Subject: question about v$session_longops >=20 > I have a script running a series of deletes. the current one has been = running for over an hour. When I check v$session_longops it shows a = previous delete statement that I know completed.=20 >=20 > Also, Im not getting any value in time_remaining.=20 >=20 > any ideas? >=20 > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- >=20 ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------