Re: RE: question about v$session_longops

  • From: <ryan.gaffuri@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 9 Feb 2004 18:46:41 -0500

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
-----------------------------------------------------------------

Other related posts: