v$rollstat

From: Dash, Saroj (CAP,CEF) <Saroj.Dash_at_gecapital.com>
Date: Mon, 20 Nov 2000 16:55:25 +0900
Message-Id: <10685.122472@fatcity.com>

In rollback segment what is the meaning of XACTS,GETS and shrinks in v$rollstat;
where can you see the value of shrinks .i.e LOw or high.

-----OE=B3'=CCf=81fbfZ=81[fW-----
=8D=B7=8Fo=90l: Nikunj Gupta [mailto:good_dba_at_hotmail.com] '-=90M"=FAZz: Monday, November 20, 2000 PM 03:21 ^=B6=90=E6: Multiple recipients of list ORACLE-L OE=8F-=BC: Re: ORA-01562: failed to extend rollback segment

Hi,

You can also commit after every update.. instead of 500 records... and try...

Increase ROLLBACK Segment Space...

HTH Nikunj

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, November 19, 2000 03:50 PM

> The problem really is that you have run out of space on your =
tablespace
for
> this rollback segment. Either make the existing datafile for the =
rollback
> segment bigger or add an additional datafile to the rollback segment.
> Allan.
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Sunday, November 19, 2000 6:50 PM
>
>
> Hi list,
> i have folling problem:
>
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.5.0.0, 64 bit - Production
> With the Partitioning and Java options
> PL/SQL Release 8.1.5.0.0 - Production
>
> declare
> *
> ERROR at line 1:
> ORA-01562: failed to extend rollback segment number 3
> ORA-01650: unable to extend rollback segment RBS03 by 640 in =
tablespace
> DDS_RBS_02
> ORA-06512: at line 13
> -----------------------------------------------------------
>
> The PL/SQL that do this is:
>
> declare
> cursor migra is select row_id from zrp_update_churnati_rowid
> where annomese_rif =3D '200001';
> i number;
> begin
> i :=3D 0;
> for rec in migra loop
> i :=3D i + 1;
> if i > 500 then
> commit;
> i :=3D 0;
> end if;
> update w_churseg_contratti_200001
> set churn_classe_cod =3D '001-03';
> end loop;
> commit;
> end;
> /
>
> thanks
> Antonio
>

________________________________________________________________________=

___
> Visit http://www.visto.com/info, your free web-based communications
center.
> Visto.com. Life on the Dot.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Antonio Idone
> INET: antoidone_at_visto.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Allan Davis Sahadeo
> INET: asahadeo_at_neal-and-massy.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
Author: Nikunj Gupta
INET: good_dba_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Mon Nov 20 2000 - 01:55:25 CST