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 817?
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).