Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE: question about v$session_longops

Re: RE: question about v$session_longops

From: <ryan.gaffuri_at_cox.net>
Date: Mon, 9 Feb 2004 18:46:41 -0500
Message-Id: <20040209234640.XPSH2412.lakemtao08.cox.net@smtp.central.cox.net>


so when do completed transactions get flushed from v$session_longops?
>
> From: John Kanagaraj <john.kanagaraj_at_hds.com>
> Date: 2004/02/09 Mon PM 06:01:47 EST
> To: "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
> 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_at_freelists.org
> >[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark
> >Sent: Monday, February 09, 2004 2:24 PM
> >To: oracle-l_at_freelists.org
> >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_at_cox.net [mailto:ryan.gaffuri_at_cox.net]
> >Sent: Monday, February 09, 2004 5:20 PM
> >To: oracle-l_at_freelists.org
> >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_at_cox.net>
> >> Date: 2004/02/09 Mon PM 05:03:47 EST
> >> To: oracle-l_at_freelists.org
> >> 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_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
> >> -----------------------------------------------------------------
> >>=20
> >
> >----------------------------------------------------------------
> >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
> >-----------------------------------------------------------------
> >----------------------------------------------------------------
> >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
> >-----------------------------------------------------------------
> >
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>



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 Mon Feb 09 2004 - 17:46:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US