Re: RE: Should percent increase higher than 0 in 817?

Jared,

I tried this 2 years back on a 8.1.6.2 databases with same result. Previously it was 505 extents with 8K blocksize on 7.3.4.5. I did not used hidded param _unlimited_rollback_segments in 7.3 which was the prereq for putting unlimited extents.

Regards
Rafiq

Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wed, 02 Jul 2003 14:39:22 -0800
Just now noticed that on 8.1.7.4 this statement:

alter rollback segment RBS1 storage ( maxextents unlimited );

results in a max_extents value of 32765, just below the point at which rollback extension would cause a crash. Jared

<[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 07/02/2003 01:55 PM
 Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:
        Subject:        Re: RE: Should percent increase higher than 0 in 

i read this somewhere. why is it a bad idea to use maxextents unlimited in your rollback tablespaces?
>
> From: "Goulet, Dick" <[EMAIL PROTECTED]>
> Date: 2003/07/02 Wed PM 04:40:45 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Should percent increase higher than 0 in 817?
>
> Guang,
>
> In temp I really don't watch anything. In Rollback I
watch for segments that are approaching maxextents and just plain running out of space.
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -----Original Message-----
> Sent: Wednesday, July 02, 2003 3:51 PM
> To: Multiple recipients of list ORACLE-L
>
>
> What are the things that we should be monitoring in ROLLBACK or TEMP
> tablespace? So far I don't have any script to monitor ROLLBACK or TEMP
> (havn't had any problem though). I too thought Oracle would take care of
> rollback and temp ts space management. Right or wrong?
>
> Guang
>
> -----Original Message-----
> Kirtikumar Deshpande
> Sent: Wednesday, July 02, 2003 2:16 PM
> To: Multiple recipients of list ORACLE-L
>
>
> After we rolled out our own scripts to monitor TS usage (de-Installing
BMC
> Patrol) following is a
> line from a Very Senior DBA's email sent to us
> (not-so-senior-DBA-team-members) yesterday:
>
> "I don't think the script should monitor ROLLBACK or TEMP tablespace for
> space issues - these
> normally resolve themselves"
>
> (I will surely get in trouble when my co-workers see this post, but what
the
> heck.. We will get
> outsourced soon anyway);) BTW, the VSDBA supports 8.1.7.4 databases.
>
> - Kirti
>
> --- "Goulet, Dick" <[EMAIL PROTECTED]> wrote:
> > That's OK, I know a couple who never heard of optimal and/or
"organization
> index" either.
> >
> > Dick Goulet
> > Senior Oracle DBA
> > Oracle Certified 8i DBA
> >
> > -----Original Message-----
> > Sent: Tuesday, July 01, 2003 7:14 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > I saw a "Sr. DBA" few years ago, who claimed he had worked with Oracle
> since
> > V4.0, and he didn't have a clue what PCTINCREASE is...
> >
> > Tanel.
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Tuesday, July 01, 2003 11:51 PM
> >
> >
> > > What about ones that you don't know?
> > >
> > > Mladen Gogala
> > > Oracle DBA
> > > Phone:(203) 459-6855
> > > Email:[EMAIL PROTECTED]
> > >
> > >
> > > -----Original Message-----
> > > Sent: Tuesday, July 01, 2003 4:11 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > PCTINCREASE is a bad good thing. Every DBA that I know of hunts
down
> > > objects with a pctincrease other than 0 and resets them.
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Gogala, Mladen
> > > INET: [EMAIL PROTECTED]
> > >
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Kirtikumar Deshpande
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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.net
> --
> Author: Guang Mei
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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.net
> --
> Author: Goulet, Dick
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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.net
--
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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.net
--
Author:
  INET: [EMAIL PROTECTED]
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. 
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
 INET: [EMAIL PROTECTED]
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).