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: question about v$session_longops

RE: question about v$session_longops

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Mon, 9 Feb 2004 15:01:47 -0800
Message-ID: <35CFD500D7BDCE43B9030BBA5979DC181D92BF@ussccem13.hds.com>


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!

>-----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
-----------------------------------------------------------------
Received on Mon Feb 09 2004 - 17:01:47 CST

Original text of this message

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