so when do completed transactions get flushed from v$session_longops? > > From: John Kanagaraj <john.kanagaraj@xxxxxxx> > Date: 2004/02/09 Mon PM 06:01:47 EST > To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx> > Subject: RE: question about v$session_longops > > Ryan, > > AFAIK, V$SESSION_LONGOPS is a FIFO table that seems to be 'permananent' (in > that it survives Db restarts). Only certain activities are recorded there-in > and only if the value of "_SQLEXEC_PROGRESSION_COST" is NOT set to zero. I > haven't seen much use for this table except in watching RMAN progress... > > John Kanagaraj > DB Soft Inc > Phone: 408-970-7002 (W) > > Disappointment is inevitable, but Discouragement is optional! > > ** The opinions and facts contained in this message are entirely mine and do > not reflect those of my employer or customers ** > > >-----Original Message----- > >From: oracle-l-bounce@xxxxxxxxxxxxx > >[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark > >Sent: Monday, February 09, 2004 2:24 PM > >To: oracle-l@xxxxxxxxxxxxx > >Subject: RE: question about v$session_longops > > > > > >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 > >----------------------------------------------------------------- > > > ---------------------------------------------------------------- > 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 -----------------------------------------------------------------