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

Don't know. I bet Dan Fink does.

He's in the air right now on his way to Portland, so I guess he won't be answering this.

I can ask him at lunch. :)

Jared

"Ryan" <rgaffuri_at_cox.net>
Sent by: ml-errors_at_fatcity.com
 07/02/2003 03:50 PM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re: RE: Should percent increase higher than 0 in 817?

does the 32k limit hold in 9i with undo tablespaces? ----- Original Message -----
To: <ORACLE-L_at_fatcity.com>
Cc: <rgaffuri_at_cox.net>
Sent: Wednesday, July 02, 2003 5:31 PM

> Due to bugs and limitations in the internal structure of rollback
> segments.
>
> ie. they aren't allowed more than 32k extents.
>
> See MetaLink note 50380.1
>
> Jared
>
>
>
>
>
> <rgaffuri_at_cox.net>
> Sent by: ml-errors_at_fatcity.com
> 07/02/2003 01:55 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
> cc:
> Subject: Re: RE: Should percent increase higher than 0 in
817?
>
>
> i read this somewhere. why is it a bad idea to use maxextents unlimited
in
> your rollback tablespaces?
> >
> > From: "Goulet, Dick" <DGoulet_at_vicr.com>
> > Date: 2003/07/02 Wed PM 04:40:45 EDT
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > 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" <DGoulet_at_vicr.com> 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" <ORACLE-L_at_fatcity.com>
> > > 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:mgogala_at_oxhp.com
> > > >
> > > >
> > > > -----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: MGogala_at_oxhp.com
> > > >
> >
> > __________________________________
> > 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: kirtikumar_deshpande_at_yahoo.com
> >
> > 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: 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.net
> > --
> > Author: Guang Mei
> > INET: gmei_at_incyte.com
> >
> > 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: 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.net
> > --
> > Author: Goulet, Dick
> > INET: DGoulet_at_vicr.com
> >
> > 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: 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.net
> --
> Author: <rgaffuri_at_cox.net
> INET: rgaffuri_at_cox.net
>
> 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: 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.net
-- 
Author: Ryan
  INET: rgaffuri_at_cox.net

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: 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.net
-- 
Author: 
  INET: Jared.Still_at_radisys.com

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: 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).