Yes, it does. (Sorry, Dan :). >From OEM I see it set to 32765.
OEM (9i R2) is still a bit dumb when it comes to undo segments, as it allowed me to *attempt* to change "Rollback Segment" _SYSSMU1$ to alter its maxextents. I received an error, of course, and alert log contained following: Fri Jul 4 11:15:48 2003 /* OracleOEM */ ALTER ROLLBACK SEGMENT "_SYSSMU1$" STORAGE ( MAXEXTENTS UNLIMITED) Fri Jul 4 11:15:48 2003 ORA-30019 signalled during: /* OracleOEM */ ALTER ROLLBACK SEGMENT "_SYSSMU1$"... In OEM, I got to the Edit window for Rollback Segments via Tablespace -> Dependencies route ;) - Kirti --- [EMAIL PROTECTED] wrote: > 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" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/02/2003 03:50 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? > > > does the 32k limit hold in 9i with undo tablespaces? > ----- Original Message ----- > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > 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 > > > > > > > > > > > > <[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 <snip> __________________________________ 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).
